Hide sheets using If Then

[ABabeNChrist]

I was thinking of using an If Then that would hide selected sheets if they are unhidden.
Of course some of these sheets may already be hidden and there may be other sheets that I wish to leave unhidden.

Only these selected sheets in code below are of the ones in concern
I just cant seem to get it to work…

Please Login or Register  to view this content.

[romperstomper]

Not much point to the If test really:

Please Login or Register  to view this content.

[ABabeNChrist]

Hi romperstomper
It works great if all sheets in array are unhidden, but I receive an error even if one sheet is already hidden, not sure why.
Error message below

[romperstomper]

Then you will have to loop and hide each individually.

[ABabeNChrist]

Thank you romperstomper
That’s what I did at first, but I was just trying to shorten up the code a little better.
But thankful I only have a couple sheets that need to be hidden.
Here are the changes I made.

Please Login or Register  to view this content.

[shg]

You can use a loop:

Please Login or Register  to view this content.

[romperstomper]

I guess Hans is still on holiday?

[ABabeNChrist]

YES
I'm sure well deserved though….