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