| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I diable Show Tabs under Option Menu
Hi I got a workbook which I would like to disable the option of showing the Tabs button as well as some other option found under the option menu so that an advanced user can not enable the show tabs option. I tried Protected workbook (No luck) Tried protecting sheet (No Luck) there must be a way. Many thanks -- funkymonkUK ------------------------------------------------------------------------ funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135 View this thread: http://www.excelforum.com/showthread...hreadid=543652 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I diable Show Tabs under Option Menu
Hi,
try this: activewindow.TabRatio=0 regards, Ivan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I diable Show Tabs under Option Menu
is there away but with without code as I do not want macro in thi workboo -- funkymonkU ----------------------------------------------------------------------- funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813 View this thread: http://www.excelforum.com/showthread.php?threadid=54365 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| engaging filter option in multple tabs | Excel Discussion (Misc queries) | |||
| Multiple Worksheet Tabs - Search Option? | Excel Worksheet Functions | |||
| DisplayWorkbookTabs: How to mirror Sheet Tabs option? | Excel Programming | |||
| Sheet tabs are hidden...option is checked | Excel Discussion (Misc queries) | |||
| Make an option to have two rows of tabs in Excel so they don't ex. | Excel Discussion (Misc queries) | |||
![funkymonkUK[_165_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
