hidding worksheet within a workbook
 

is there a way to hide/unhide a worksheet in a given workboot without
disturbing the other worksheets of that workbook?

hidding worksheet within a workbook
 

Use these 3:

Sheets(1).Visible = True ' unhide a sheet
Sheets(1).Visible = False ' hide a sheet
Sheets(1).Visible = xlVeryHidden ' really hide a sheet - sheet can only be
accessed with code.

you can use Sheets("Sheet1")
or
set wkst = Sheets("Sheet1")
wkst.Visible=True
--
steveB

Remove "AYN" from email to respond
"Colin2u" wrote in message
...
is there a way to hide/unhide a worksheet in a given workboot without
disturbing the other worksheets of that workbook?