How do I gray out worksheet tabs in EXCEL
 

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

How do I gray out worksheet tabs in EXCEL
 

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 ?

How do I gray out worksheet tabs in EXCEL
 

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 ?

How do I gray out worksheet tabs in EXCEL
 

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 ?

How do I gray out worksheet tabs in EXCEL
 

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 ?

How do I gray out worksheet tabs in EXCEL
 

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 ?

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 ?