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.

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.

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

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