Thread: Hide Sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ken Wright Ken Wright is offline
external usenet poster
 
Posts: 634
Default Hide Sheet

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?