Is there a way to customize what group of worksheets will visible in excel?

[Excel New]

Hello,
I am currently working on a workbook with 500 worksheets.
I don't really need all the sheets to be visible all the time so I hide some of them from time to time (especially when I'm printing) and its very time consuming.

Is there a way to customize what sheets will be visible in excel?
I want to divide the 500 worksheets into different groups, so that whenever I choose a group, only the worksheets that belong to that group will be visible, and others will be hidden.

I know this is somehow possible thru "custom view", but the problem is that most of my sheets are protected sheet.

Is there any other way to make this happen?

Thanks in advance for the help!

[AliGW]

Only using VBA - shall I move the thread for you?

[Excel New]

Thanks for the reply.

I'm not really knowledgeable in VBA, but willing to consider if there's no other alternative.

[AliGW]

Thread duly moved.

[torachan]

You could write a macro or use a userform as per the attached.
then assign groups of sheets to checkboxes.

[Excel New]

Thanks for the advise!