View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
johne johne is offline
external usenet poster
 
Posts: 40
Default hiding worksheets programmatically

That I know. I need to use code to hide them. The number of the sheets will
vary from run to run.
.... John


"JLGWhiz" wrote:

Click on the sheet tab to activate it, then

FormatSheetHide


"JohnE" wrote:

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