View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mike Middleton Mike Middleton is offline
external usenet poster
 
Posts: 762
Default Is there any way to create a folder structure for tabs in a workbo

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



"Curious" wrote in message
...
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?