xlSheetVerryHidden not working

**Gzdnkh** · 05-21-2013, 06:53 AM

Hello,
Excel 2010: I use

Please Login or Register  to view this content.

to hide sheets I need to be hidden.

They disappear from the lower tab but I can still "unhide" them manually.

I attach a file with two simple macros to show the problem as I am not sure I can explain it clearly.
I have pasted screenshots in the file showing how I can "unhide" verry hidden sheets

Please help I am stuck with this one.

**TMS** · 05-21-2013, 06:58 AM

You're spelling it the Scottish way with too many rrrrr's ... It only has one: xlVeryHidden

Regards, TMS

**Gzdnkh** · 05-21-2013, 07:20 AM

...there should be a smilie for facepalm.

On the side note - why did it "half" work then? Someone at Microsoft has spelling problems as well?

**JosephP** · 05-21-2013, 07:44 AM

because the default value for a numeric variable is 0 so that is what xlsheetverryhidden is interpreted as and that happens to be the literal value of xlSheetHidden

**TMS** · 05-21-2013, 07:48 AM

Thanks for the rep

It's not "half working" ... you have offered it a VBA constant which hasn't been defined. Consequently, it is using a value of 0 which gives you xlSheetHidden.

If you use Option Explicit at the top of all your code modules, you will get errors highlighted ... I'm sure this would have been picked up as an undefined variable.

Regards, TMS