Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO REMOVE 'SHEET TABS' FROM OPTIONS MENU IN VB
DEAR ALL
I have about 18 sheets and do not want end users to keep accessing those sheets aimlessly. Hence I have removed the sheet tabs. But the users still go to -options-sheet tabs- and activate it. Then I used macro and removed the -options- from TOOLS. Then I myself could not activate the -options- in the TOOLS and have to reload excel97 again. So pls advice better solution to remove the sheet tabs option using VB. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO REMOVE 'SHEET TABS' FROM OPTIONS MENU IN VB
Sheets can either be Visible, Hidden or Very Hidden. If you want to you could
use that to make the tabs only visible one at a time. Just be sure that there is always at least one sheet visible at all times. Sheet1.Visible = xlSheetVeryHidden -- HTH... Jim Thomlinson "CAPTGNVR" wrote: DEAR ALL I have about 18 sheets and do not want end users to keep accessing those sheets aimlessly. Hence I have removed the sheet tabs. But the users still go to -options-sheet tabs- and activate it. Then I used macro and removed the -options- from TOOLS. Then I myself could not activate the -options- in the TOOLS and have to reload excel97 again. So pls advice better solution to remove the sheet tabs option using VB. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO REMOVE 'SHEET TABS' FROM OPTIONS MENU IN VB
On Feb 7, 4:29 am, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote: Sheets can either be Visible, Hidden or Very Hidden. If you want to you could use that to make the tabs only visible one at a time. Just be sure that there is always at least one sheet visible at all times. Sheet1.Visible = xlSheetVeryHidden -- HTH... Jim Thomlinson "CAPTGNVR" wrote: DEAR ALL I have about 18 sheets and do not want end users to keep accessing those sheets aimlessly. Hence I have removed the sheet tabs. But the users still go to -options-sheet tabs- and activate it. Then I used macro and removed the -options- from TOOLS. Then I myself could not activate the -options- in the TOOLS and have to reload excel97 again. So pls advice better solution to remove the sheet tabs option using VB. THANK YOU JIM. Will try what u sugested but if the sheets are hidden some functions may not perform. But can u tell me how to get the tools-option restored once i i remove it by using macro |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO REMOVE 'SHEET TABS' FROM OPTIONS MENU IN VB
ActiveWindow.DisplayWorkbookTabs = True
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "CAPTGNVR" wrote in message ups.com... On Feb 7, 4:29 am, Jim Thomlinson <James_Thomlin...@owfg-Re-Move- This-.com wrote: Sheets can either be Visible, Hidden or Very Hidden. If you want to you could use that to make the tabs only visible one at a time. Just be sure that there is always at least one sheet visible at all times. Sheet1.Visible = xlSheetVeryHidden -- HTH... Jim Thomlinson "CAPTGNVR" wrote: DEAR ALL I have about 18 sheets and do not want end users to keep accessing those sheets aimlessly. Hence I have removed the sheet tabs. But the users still go to -options-sheet tabs- and activate it. Then I used macro and removed the -options- from TOOLS. Then I myself could not activate the -options- in the TOOLS and have to reload excel97 again. So pls advice better solution to remove the sheet tabs option using VB. THANK YOU JIM. Will try what u sugested but if the sheets are hidden some functions may not perform. But can u tell me how to get the tools-option restored once i i remove it by using macro |
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 | |||
My sheet tabs disappeared. Options shows they are active. | Excel Discussion (Misc queries) | |||
Sheet Tabs options greyed out | Excel Discussion (Misc queries) | |||
I have no access to the "tabs" on the options menu of excel | Excel Discussion (Misc queries) | |||
Disable "Sheet tabs" check box under [Tools][Options]-[View] tab | Excel Programming |