Problem with hiding ALL sheets?
 

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

Problem with hiding ALL sheets?
 

Gotta have, at least, one.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Robert Crandal" wrote in message
...
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

Problem with hiding ALL sheets?
 

Hi,

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

Mike

"Robert Crandal" wrote:

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


.

Problem with hiding ALL sheets?
 

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

"Robert Crandal" wrote in message
...
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