activesheet.visible=xlveryhidden

to unhide

worksheets("Sheet1").visible=true

--

HTH

Bob Phillips

"AA2e72e" wrote in message
...
How can a sheet be hidden such that it cannot be unhidden
via Format | Sheet | Unhide?

And don't forget to protect the VBA project, as otherwise they will be able to go into the VBE,
see that a hidden sheet exists and write their own piece of code to show it if they know how.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"Bob Phillips" wrote in message
...
activesheet.visible=xlveryhidden

to unhide

worksheets("Sheet1").visible=true

--

HTH

Bob Phillips

"AA2e72e" wrote in message
...
How can a sheet be hidden such that it cannot be unhidden
via Format | Sheet | Unhide?

for a worksheet, they can just click on the sheet in the project explorer,
select properties and change visible from xlSheetVeryHidden to
xlSheetVisible.

Regards,
Tom Ogilvy

"Ken Wright" wrote in message
...
And don't forget to protect the VBA project, as otherwise they will be
able to go into the VBE,
see that a hidden sheet exists and write their own piece of code to show
it if they know how.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

--------------------------------------------------------------------------
--
Attitude - A little thing that makes a BIG difference
--------------------------------------------------------------------------
--



"Bob Phillips" wrote in message
...
activesheet.visible=xlveryhidden

to unhide

worksheets("Sheet1").visible=true

--

HTH

Bob Phillips

"AA2e72e" wrote in message
...
How can a sheet be hidden such that it cannot be unhidden
via Format | Sheet | Unhide?