PDA

View Full Version : Solved: display sheet only when call, hide sheet when not in use.



MNJ
12-01-2006, 12:12 AM
Hi folks,

May I know how to hide sheets and display only once they are summoned from a button? And hide them once again when they are no longer an active sheet.

Thanks in advance. :bow:

Simon Lloyd
12-01-2006, 12:26 AM
Sheets are hidden like this Sheets("Sheet1").Visible = False and made visible like this Sheets("Sheet1").Visible = Trueyou cannot make all sheets hidden, if you want to hide the only sheet visible in your workbook you must first make another one visible.

Regards,
Simon

noobie
12-03-2006, 07:05 PM
thanks. I didn't know it was that easy.
:bouncy: