He says he knows how to set the Sheet Tabs to hidden - sounds like he wants
to see how to hide the sheets and prevent the user from unhiding them.
Hidding the tabs was one (unsuccessful attempt). If you reread it, do you
disagree?

--
Regards,
Tom Ogilvy

"gocush" /delete wrote in message
...
I think the OP wants to hide the Tabs rather than the sheets



"Dick Kusleika" wrote:

Ted wrote:
A small problem ...
I know how to set Sheet Tabs to be hidden in VBA but I can't see how I
can
stop the user from going to the Tools-- Options menu and unhiding
them
(which makes hiding them a bit pointless).
What am I missing?

Ted:

Set the Visible property to xlSheetVeryHidden. The only way to unhide
it
will be through VBA.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com