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

[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.

 

[Jim Thomlinson]

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

 

[CAPTGNVR]

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

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

 

[Bob Phillips]

ActiveWindow.DisplayWorkbookTabs = True

--
---
HTH

Bob

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