Expand and Collapse Tabs Help

Copper Contributor

I've attached a sheet that I am seeking help in understanding how to create/write the code to collapse and expand multiple sheets. Specifically, I would like to be able to collapse and expand all of the purple colored "SW1...etc" sheets into a SW1 tab and do the same thing with the red colored "SW2...etc" sheets into another SW2 tab. 

1 Reply

@Chris00135 

See the attached workbook (now a .xlsm)