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.