Thread: Hide a Sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 292
Default Hide a Sheet

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

"AQ Mahomed" skrev i melding
...
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!