Thread: Hide Sheet
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Hide Sheet

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?