View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas[_2_] Gary Keramidas[_2_] is offline
external usenet poster
 
Posts: 364
Default hiding worksheets programmatically

you can try these

worksheets("Sheet1").visible = false
worksheets("Sheet1").visible = true
worksheets("Sheet1").visible = xlveryhidden

--

Gary


"JohnE" wrote in message
...
I have an inherited workbook that when it is all done running the
scenarios,
etc, there are a extra sheets. These have the standard "Sheet" + number
on
the tab while those reviewed and needed are actually named. I would like
to
hide these unused sheets at the end of the running process. But I am at a
loss of how that would be accomplished, so I seek help from the group.
Thanks.
... John