How do I gray out worksheet tabs in EXCEL
Even easier !!
"NickHK" wrote:
Michael,
If I save a WB with the tabs hidden, then save/close, they are still hidden
upon reopening.
NickHK
"Michael" ...
Yes, I can then cut'n'paste the relevant code into the WorkBook_Open
event.
Thanks
"NickHK" wrote:
Michael,
Record a macro to see the correct syntax.
NickHK
"Michael" ...
Thanks,
I want to stop users navigating via tabs - can I clear the option
'Sheet
tabs' in the tools-options menu using VBA in the Workbook_Open event
"Tom Ogilvy" wrote:
Why not just hide the sheet. There is no provision for disabling a
tab.
--
Regards,
Tom Ogilvy
"Michael" wrote:
I would like to gray out worksheet tabs on opening an application,
and
enabling the tab via a macro. Is this possible ?
|