Is there any way to create a folder structure for tabs in a workbo

C

Curious

I work with spreadsheets with many tabs, and it would be nice if I could see
only groupings of tabs at the bottom...and then do something like double
click on a grouping to see all the tabs. Example: tabs a,b,c,...1,2,3...;
but on the bottom I would only see folder tabs "alphabet" and "numbers"...and
then I could double click on one of them to see the sub-tabs. Is this
possible?
 
R

Roger Govier

Hi

No this is not possible, without writing VBA code to hide "sets" of Sheets
and unhide others.
You could label your sheets as A1, A2 ... B1 B2 etc.,
There is code available on Chip Pearson's site that will sort sheets in
alpha order for you.
http://www.cpearson.com/Excel/sortws.aspx

There are several add ins that have been written which allow you to have a
floating toolbar to enable sheet selection.
One such example would be Dave Peterson's, which can be found at.
http://www.contextures.com/xlToolbar01.html

or for XL2007 the code has been modified by Ron de Bruin
http://www.contextures.com/xlToolbar01b.html
 
M

Mike Middleton

Curious -

I think you would need VBA to do exactly what you want.

If I had a large number of worksheets in a workbook, I'd right-click one of
those navigation arrows at the extreme left of the worksheet tabs, bringing
up a list of the worksheets that can be selected. (This feature does not
organize the worksheets in folders, but it does give a more complete listing
of worksheets than what you can see as worksheet tabs.)

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top