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
|