Hide Sheets
 

Hi: Can any one please tell me how to i hide the sheets?

Thanks,

Hide Sheets
 

Assuming you want to hide one of the worksheets. As an example, if the
sheet name is Test Sheet, here is how to hide it.

Sheets("Test Sheet").Select
ActiveWindow.Visible = False

Hope this helps.
J.O.

Anna wrote:
Hi: Can any one please tell me how to i hide the sheets?

Thanks,

Hide Sheets
 

Should i simple type this code into VBA by prssing Alt F11 or i have to
create a function?

Thanks,

John Bundy wrote:
You can do it like this
Sheets("sheet2").Visible = False
Just change sheet2 to the name of your sheet, leave the "" in.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Anna" wrote:

Hi: Can any one please tell me how to i hide the sheets?

Thanks,