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