Hide & Unhide specific sheets Macro Check and Advice

Thanks Fotis. I've edited the posted and included the code tags.

I would start with adding

Please Login or Register  to view this content.

to the beginning of your code

and
at the end (before your end sub)

Please Login or Register  to view this content.

Is there a reason you need dynamic sheet selection?

Only I notice the very first section of your macro hides the sheet your looking at and the next one. Is that by design?

Thank you Nickmax1. This is a smart solution!

Originally Posted by swoop99

Is there a reason you need dynamic sheet selection?

Only I notice the very first section of your macro hides the sheet your looking at and the next one. Is that by design?

Yes, I put those sheets in groups. Say we have 100 sheets in workbook, including 10 for class A, 20 for class B, 25 for class C ... You wouldn't want to manually select them.

Would it be easier to have 3 different macros, all run by either CTRL-whatever or buttons on a master sheet, that toggle hiding for all sheets of a particular class?

What is your sheet naming convention like? ie, this'll be really easy if all your Class A sheets starts with "A". For example.

huard

I think a sample workbook is needed.

Originally Posted by nickmax1

huard

I think a sample workbook is needed.

Thanks Nickmax1. I think your answer has solved the problem.