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" <Colin2u@discussions.microsoft.com> wrote in message
news:914E0766-A90D-4C1F-8458-914B81BCFD7A@microsoft.com...
> is there a way to hide/unhide a worksheet in a given workboot without
> disturbing the other worksheets of that workbook?