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.
See the attached version, now a macro-enabled workbook.
HansVogelaar
I need to create more collapsible tabs (12 for each month of the year). How do I add more collapsible tabs? I would greatly appreciate your help!
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
HansVogelaar
Your template only has A-C but I will need A-L. Any way you can make a template that has A-L with a permanent page that stays unhidden at all times for a master data entry sheet?Do you really want the sheets to be named A to L? Or should they be named after the months of the year?