ActiveSheet.Visible = xlVeryHidden

[pcc]

I have this code assigned to a commandbutton on a sheet

ActiveSheet.Visible = xlVeryHidden

When I click the button, the sheet is hidden, but only hidden, not xlveryhidden - ie it can be unhidden using Format>Sheet>Unhide, and it shows up in VB Explorer with Property Visible = 0 - xlSheetHidden

I must be missing a trick but can't think what.
Can anyone enlighten me?

Cheers

 

[Andrew Poulsom]

It worked for me (XL2000).

 

[pcc]

Thanks Andrew, but it still won't for me!
Anyone out there on Excel 2000 who can try it?

 

[fairwinds]

Works for me too.

 

[Andrew Poulsom]

I am on Excel 2000. What other code do you have assigned to your CommandButton? Where is the CommandButton from?

 

[Ivan F Moala]

Try

ActiveSheet.Visible = xlSheetVeryHidden


OR

ActiveSheet.Visible = 2


Looks like your const may not be recognised and defaults to 0 = hidden sheet and NOt VeryHidden

 

[pcc]

Sorry, false alarm.
The code works OK but afetr the

ActiveSheet.Visible = xlVeryHidden

bit there was some othe code runnng which unhid the sheet and rehid it again, but that code only hid the sheet,
not 'veryhid' it!!

Thanks for taking time out and apologies for being a pratt