HIDE A SHEET?

Posted by Katje on September 01, 2001 2:34 PM

Hi everyone,

I've got a question and I hope someone can help me out. My question is if it's possible to hide a sheet by using a macro that will be activated by clicking on a macro on an other sheet. I want the opening sheet only to be open when you start the program and after that I want it to open "Sheet2" and if you press another button to hide "Sheet2". I hope someone can help me with this if it's possible? Thanks in advance.

Katje

Posted by Robb on September 01, 2001 7:19 PM

Katje

In the button code, try:

To hide the sheet (say sheet2)

Sheets("Sheet2").Visible = False

To make the sheet visible again:

Sheets("Sheet2").Visible = True

Any help?

Regards