Expand and Collapse Tabs Help

%3CLINGO-SUB%20id%3D%22lingo-sub-2795303%22%20slang%3D%22en-US%22%3EExpand%20and%20Collapse%20Tabs%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2795303%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20attached%20a%20sheet%20that%20I%20am%20seeking%20help%20in%20understanding%20how%20to%20create%2Fwrite%20the%20code%20to%20collapse%20and%20expand%20multiple%20sheets.%20Specifically%2C%20I%20would%20like%20to%20be%20able%20to%20collapse%20and%20expand%20all%20of%20the%20purple%20colored%20%22SW1...etc%22%20sheets%20into%20a%20SW1%20tab%20and%20do%20the%20same%20thing%20with%20the%20red%20colored%20%22SW2...etc%22%20sheets%20into%20another%20SW2%20tab.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2795303%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New 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)