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
 

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

Hierarchy of Codename and error catching if no worksheet. 1
unhiding / hiding sheets 5
before save event 2
Open Event Code Bug 4
xlSheetVeryHidden vs xlSheetVisible 11
Keep lot of sheets Displayed and Hide Other 2
HIDE / UNHIDE sheets based on user answers 5
Making sure the user is able to run macros 1

Top