Hide a Sheet

H

Harald Staff

Hi AQ

Sub test()
Sheets(2).Visible = False
Sheets(3).Visible = xlVeryHidden
End Sub

Sheet3 will be invisible also in the Format > Sheet > Unhide menu.

HTH. Best wishes Harald
 
H

Harald Staff

ross said:
also try:
format > sheets > hide

You're absolutely right, Ross. Since this is the programming newsgroup I
assumed code, but there's nothing indicating that in the original question.

Best wishes Harald
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top