Collapsing Worksheets

[qegsrich]

Is there a way to group worksheets together and have them hidden until their "Group sheet" is clicked?

For example;

I have, "sheet1" through to "sheet4" and "Group1" & "Group2"

Could I have "Group1 + Group2" always showing, and when "Group1" sheet is clicked, it un-hides "sheet1" & "sheet2"
and when "Group2" is clicked, "sheet3 + sheet4" will display?
I would also like the "sheets" to hide again once the "group" sheets are no longer active.
I have found some vba coding that does something very similar, but I struggled to edit it to my requirements.

Thanks in advance.

Rich

 

[wigi]

You can use the Worksheet_Activate and Worksheet_Deactivate events.
When they fire, you hide and unhide the correct sheets.

 

[qegsrich]

Thanks, I've managed to get that working. The issue i'm having now is; If i click "Group1" and it shows "Sheet1" + "Sheet2", How can I use those sheets without triggering the "Worksheet_Deactivate" on the "Group1"

 

[wigi]

You can set Application.EnableEvents = False, let VBA select the correct tab, then set Application.EnableEvents = True again.