| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 ? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 ? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 ? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 ? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 ? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Worksheet Tabs | Excel Discussion (Misc queries) | |||
| When I open a saved worksheet, it opens with a gray background | Excel Discussion (Misc queries) | |||
| Can Excel worksheet tabs be relocated above the worksheet? | Excel Discussion (Misc queries) | |||
| why does my excell worksheet start with only a gray view, no data | Excel Worksheet Functions | |||
| Excel worksheet tabs | Excel Programming | |||
Linear Mode
