Forum Discussion
Solved
Need help on Collapsing and Expanding Worksheet Tabs in Excel
Hi, I want to create tabs in excel that expands and shows other tabs associated with it. For example, I have tabs A, A1, A2, A3, B, B1, B2, B3 . . etc. I want tabs A1, A2, A3 and be shown only whe...
See the attached version, now a macro-enabled workbook.
I will need 5 sheets (ex. January Week 1, January Week 2, January Week 3, January Week 4, January Week 5) hidden for each month. I hope that makes sense? Sorry if it's confusing.
See the attached sample workbook. The code is in the ThisWorkbook module.
- This is amazing! Thank you so much for your help!