How do I gray out worksheet tabs in EXCEL

[Guest]

I would like to gray out worksheet tabs on opening an application, and
enabling the tab via a macro. Is this possible ?

 

[Guest]

Why not just hide the sheet. There is no provision for disabling a tab.

 

[Guest]

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

 

[NickHK]

Michael,
Record a macro to see the correct syntax.

NickHK

 

[Guest]

Yes, I can then cut'n'paste the relevant code into the WorkBook_Open event.

Thanks

 

[NickHK]

Michael,
If I save a WB with the tabs hidden, then save/close, they are still hidden
upon reopening.

NickHK

 

[Guest]

Even easier !!

Michael,
If I save a WB with the tabs hidden, then save/close, they are still hidden
upon reopening.

NickHK