hiding work sheets in exel 2

[R9772]

can someone help me find a way to hide a work sheet in exel...or is this even possible?

 

[starsky51]

I'm assuming you're asking how to do it in vba:

ActiveWorkbook.Sheets("Sheet Name Here&quot.Visible = xlSheetVeryHidden


starsky51.

 

[R9772]

Thanks!

 

[VBAjedi]

Just be aware that "VeryHidden" sheets can only be unhidden via code (the Excel Format>Sheet>Unhide command won't work). To mimic the hide method used from Excel, just use:

ActiveWorkbook.Sheets("Sheet Name Here&quot.Visible = False

which would allow it to be unhidden from the Excel menu (subject to any password you put on it).

To undo either method, use:

ActiveWorkbook.Sheets("Sheet Name Here&quot.Visible = True


Hope that helps!

VBAjedi

 

[R9772]

Thanks for the heads up!