HOW TO REMOVE 'SHEET TABS' FROM OPTIONS MENU IN VB

  • Thread starter Thread starter CAPTGNVR
  • Start date Start date
C

CAPTGNVR

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.
 
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
 
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
Click to expand...

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
 
ActiveWindow.DisplayWorkbookTabs = True

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top