hidding worksheet within a workbook

[Colin2u]

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

[STEVE BELL]

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" <[email protected]> wrote in message
news:[email protected]...
> is there a way to hide/unhide a worksheet in a given workboot without
> disturbing the other worksheets of that workbook?