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

hi jwahlton

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

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


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

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

"jwahlton" wrote:

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

A couple mo

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

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

If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
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.)

jwahlton wrote:

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

--

Dave Peterson

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

On Wed, 23 Jul 2008 09:15:01 -0700, jwahlton
wrote:

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

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

On Jul 23, 5:15*pm, jwahlton
wrote:
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