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.
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?
I would appreciate the months however, it will be a fiscal year for me so it will need to start July to June instead of January to December
Thanks. And how would you like to show/hide those sheets?