Hide a Sheet
 

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!

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!

Hide a Sheet
 

also try:
format sheets hide

ross

Hide a Sheet
 

"ross" skrev i melding
om...
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