'''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''
how I can
stop the user from going to the Tools-- Options menu and unhiding them
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''

The above is what leads me to think the OP is only concerned with the TABS,
rather than the visibility of the SHEETS themselves. Going to ToolsOptions
leads the user to the location for hiding/unhiding the TABS. While sheets
are hidden/unhidden thru the Format menu.

In order to prevent a user from unhiding the TABS (of visible sheets) the
developer could disable either the Option menu, the Tools menu or create a
new custom Menubar minus the Option menu.
"Tom Ogilvy" wrote:

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