Thread: Hide Sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_5_] Bob Phillips[_5_] is offline
external usenet poster
  
Posts: 620
Default Hide Sheet
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?


Reply With QuoteReply With Quote