View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CAPTGNVR CAPTGNVR is offline
external usenet poster
 
Posts: 115
Default 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.