Hide a Sheet

[AQ Mahomed]

Hi

Is is possible to hide a sheet.

Many Thanks
AQ



*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[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

 

[ross]

also try:
format > sheets > hide

ross

 

[Harald Staff]

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