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

[MNJ]

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.

[Simon Lloyd]

Sheets are hidden like this [VBA]Sheets("Sheet1").Visible = False [/VBA]and made visible like this [VBA]Sheets("Sheet1").Visible = True[/VBA]you 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]

thanks. I didn't know it was that easy.