Group Worksheet Tabs and Minimise

[daveburke114]

Hi All,

As discussed in another thread thats now sorted (thanks!) I have a large workbook that will contain many worksheets.

Is it possible (via an add-on if necessary) to group and minimise a selection of worksheet tabs?

For example;
If I had 10 worksheets for 10 different Accounts, then 5 more worksheet for other details, could I group the 10 Accounts sheets so I only had 6 tabs accross the bottom of the screen?

Thanks
Dave

 

[GlennUK]

And what behaviour ( and what would you expect to see ) do you want from this "grouped" tab?

 

[daveburke114]

---Ooops I thought this had posted days ago!---


To be honest im not too sure! I would like to just free up some space along the bottom tab bar.

For example, say I have:
10 worksheets with Cutomer Purchase Details
5 Sheets with Suppliers name and addresses
1 Sheet of Bank account details
1 Sheet of Cash Flow
TOTALING 17 TABS

I would like to be able to group the 'Customer Purchase Details' into one tab, and the Suppliers names into another.
So along the bottom of the screen there would only 4 Tabs:
Customers
Suppliers
Bank Account
Cash Flow

etc

Then if I wanted to explore the customer details I could just expand that tab to reveal all 10 worksheets!


Thats what I was thinking, but I'm open to any ideas of other ways or methods people have

Thanks
Dave

 

[GlennUK]

Do you know that right-clicking the tab scroll buttons ( to the left of the tabs ) gives a pop-up of available tabs? Although for 17, I think only 15 would show, and you'd have to click "More Sheets ..." which then shows a listbox of tabs ... and then that's more clicks I'd be happy with. Or you could have a menu screen with hyperlinks to your sheets, and outline the rows containing the hyperlinks to have just the structure you describe.

Or, if you really really want to have "group" tabs ... you'll need a dummy tab for each group, and code to hide/unhide various sheets when certain actions take place ... for example, use the Worksheet_Activate event command to test whether a "group" tab has been activated and then unhide all associated tabs. And then you'd have to think of what logic to use for testing when to re-hide them. It seems like a lot of trouble for a little functionality.

 

[daveburke114]

yup sounds like a total nightmare!

thought there might me a handy little plug-in or workaround but never mind!

I will probably go down the index page route!

Cheers
Dave