I've got too many worksheets

I have this workbook with about 20+ worksheets, is there any way for me to organize them (besides dragging them left and right) in some hierachical fashion so that i can browse through them quickly?

Originally Posted by starguy

Hi
If you want to quickly access the sheets wihtout scrolling with sheet buttons you can do this by right clicking on the sheet scrolling buttons (at the left side of first sheet tab), it will give you the list of all sheets in the workbook so you can click on the sheet name to go to that sheet.

cool.

i was hoping more for organizing it using headers where the sheet buttons when clicked activate drop down lists of the worksheets i put in that header.
But i guess that cant be done rite?

Here is a macro that I wrote with the help of the people of this forum to create a Table of Contents page with hyperlinks. It ignores hidden worksheets. You need to run it from a blank worksheet which becomes your table of contents. I keep it in my "Personal" workbook which because I use it so much.

Please Login or Register  to view this content.

Is this what you need?

ChemistB

Originally Posted by ChemistB

Here is a macro that I wrote with the help of the people of this forum to create a Table of Contents page with hyperlinks. It ignores hidden worksheets. You need to run it from a blank worksheet which becomes your table of contents. I keep it in my "Personal" workbook which because I use it so much.

Please Login or Register  to view this content.

Is this what you need?

ChemistB

cool thanks!

Not really what i wanted though but between you and starguy i think i have enough.