| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable "Sheet tabs" check box under [Tools][Options]-[View] tab
Does anyone know how to programmatically disable the "Sheet tabs" check box
on the <Tools <Options - [View] tab? If so, could you please post example code? Thanks in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable "Sheet tabs" check box under [Tools][Options]-[View] tab
ActiveWindow.DisplayWorkbookTabs = False
"quartz" wrote: Does anyone know how to programmatically disable the "Sheet tabs" check box on the <Tools <Options - [View] tab? If so, could you please post example code? Thanks in advance. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable "Sheet tabs" check box under [Tools][Options]-[View] t
Kassie,
Thanks for your response, but I want this control DISABLED not set to false. Any clue on how to do this? "Kassie" wrote: ActiveWindow.DisplayWorkbookTabs = False "quartz" wrote: Does anyone know how to programmatically disable the "Sheet tabs" check box on the <Tools <Options - [View] tab? If so, could you please post example code? Thanks in advance. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable "Sheet tabs" check box under [Tools][Options]-[View] tab
No can do... To the best of my knowledge...
"quartz" wrote: Does anyone know how to programmatically disable the "Sheet tabs" check box on the <Tools <Options - [View] tab? If so, could you please post example code? Thanks in advance. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable "Sheet tabs" check box under [Tools][Options]-[View] t
Jim, thanks for your reply. I was afraid that would be the answer...
"Jim Thomlinson" wrote: No can do... To the best of my knowledge... "quartz" wrote: Does anyone know how to programmatically disable the "Sheet tabs" check box on the <Tools <Options - [View] tab? If so, could you please post example code? Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| tabs are missing even though 'tools-options-view-sheet tabs' ok? | Excel Worksheet Functions | |||
| "Show Placeholders" in options/view menu does'nt work. | Excel Discussion (Misc queries) | |||
| "Show Placeholders" in options/view menu does'nt work. | Excel Discussion (Misc queries) | |||
| "Show Windows in Taskbar" option from the ToolsOptionsView broke | Excel Discussion (Misc queries) | |||
| clicking TOOLS/OPTIONS gives me error msg "cannot access dir D:/" | Excel Discussion (Misc queries) | |||
![quartz[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
