Is there a way to Alphabetize worksheets?

[jwahlton]

I've got a big file with 60+ worksheets. Is there a way to alphabetize all
of the worksheets? Otherwise I have to scroll through all of them to find
the one I need. Thank you

 

[Ron de Bruin]

hi jwahlton

See
http://www.contextures.com/xlToolbar01.html

2007 version
http://www.contextures.com/xlToolbar01b.html

 

[FSt1]

hi
another option might be to right click the sheet navigator at the lower left
of the screen to get a pop up list of your sheets. with 60 sheets, click the
more sheets options for a scrollable text box with all your sheets.

regards
FSt1

 

[Dave Peterson]

A couple more:

Chip Pearson's:
http://www.cpearson.com/excel/sortws.htm

David McRitchie's:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#sortallsheets

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

 

[Gord Dibben]

Alternative..................

Don't bother to sort them and use of these methods to select them

You can build a Navigation Toolbar as per Dave's code on Debra Dalgleish's
site. Sorts as well as navigates.

http://www.contextures.on.ca/xlToolbar01.html

Or see this google search thread for the BrowseSheets macro from Bob
Phillips.

http://tinyurl.com/yoa3dw


Gord Dibben MS Excel MVP

 

[Pete_UK]

Off topic, but I find that word very strange - "alphabetize". If you
were talking about just a list of numbers, would you use "numberize"?
What's wrong with the word "sort"?

Pete