Aug 29 2020 10:43 AM
I have a file with a large number of sheets. I would like to create a way to expand and collapse the tabs for ease of use.
I've found an example code and file here that is what I would like to do: https://www.experts-exchange.com/articles/1685/Excel-Using-a-Sheet-Tab-as-a-Button-for-Expanding-Col...
However, I believe the code is written to hide all tabs EXCEPT (sheet names). I need the code to say hide tabs (sheet names). As an example, in the sample file I would like the "Show My Guts" button to only expand/collapse "Calcs1" and "Calcs 2", and leave the rest of the tabs remaining. Because I have so many tabs in my actual file and will be adding more in the future, I do not want to have to add every sheet name to the code so that it won't get collapsed.
Thank you very much for any help you can offer!
Aug 29 2020 10:50 AM
Aug 29 2020 11:20 AM
It is a pro forma excel file, so there are many different worksheets set up to create a financial model. Then I have inputted monthly accounting summaries as separate tabs, each which is referenced throughout the various sheets per month in various formulas. I would like to have all of these monthly accounting sheets collapsible, since there are so many and more for holding data. I do not want to reference other excel files because links often are broken and I'm working off the network at home due to COVID.