Problem with hiding ALL sheets?

  • Thread starter Thread starter Robert Crandal
  • Start date Start date
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
 
Hi,

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

Mike
 
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
 
Back
Top