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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

before save event 2
Hide sheet - Help 4
Hierarchy of Codename and error catching if no worksheet. 1
Workbook_BeforeClose 2
hide multiple worksheets based on a formula value in one cell 1
Open Event Code Bug 4
xlSheetVeryHidden vs xlSheetVisible 11
Hide all Sheets 4

Back
Top