Sep 29 2021 06:50 AM
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.
Sep 29 2021 07:45 AM
See the attached workbook (now a .xlsm)