Problem with hiding ALL sheets?

R

Robert Crandal

Does Excel have a problem if I want to set ALL of
sheets' visible property to "xlSheetVeryHidden"???
My code crashes if I try to hide my my last sheet.
I'm wondering if my code is flawed, or maybe Excel
just doesnt accept making everything "very hidden"??

thank you
 
M

Mike H

Hi,

No it's a (valid) limitation of Excel you cannot hide all sheets, at least
one must remain visible.

Mike
 
H

Harald Staff

You can hide the window. Or, if this is permanent, save as an addin file
(xla, xlam), which is a workbook with invisible sheets.

HTH. Best wishes Harald
 
Top