Hide Sheets Error

[crazyforexcel]

Hi,

If I run the 'HideCalendarSheets()' when the sheets are already hidden it goes to debug. Is there a way to exit the code if the sheets are hidden?

Thank you

Please Login or Register  to view this content.

[mikerickson]

There are problems with using a Sheets object when some of the included sheets are hidden.
You can solve that by hiding the same way that you un-hide, with

Please Login or Register  to view this content.

[Logit]

.
Another method. Did not include sheet 1 as there must be at least one sheet visible at all times.

Please Login or Register  to view this content.

[crazyforexcel]

There are more sheets in the workbook that will always stay in view.

[crazyforexcel]

I can't seem to get either one to work sorry.

[Logit]

Refer to the attached file.

[crazyforexcel]

Thanks Logit but the only sheets that I want to hide are 1-12 for the Calendar months.

[Logit]

Please Login or Register  to view this content.

[crazyforexcel]

That is perfect thanks for all of your help.

[Logit]

You are welcome.