Can you sort the worksheets in a workbook

[CarolineHedges]

In my workbook I have about 70 worksheets, but I want them i
alphabetical order. Is there a quick way I can do this by selecting al
sheets and then sorting, or do I really have to go into each one and d
it manually

 

[Dave Peterson]

You can drag and drop manually...

or

You could use a macro:

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, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Jim Cone]

Caroline,
Or check out the free Excel add-in "Excel Extras".
Download from (no registration required) ...
http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA


"CarolineHedges"
wrote in message ...
In my workbook I have about 70 worksheets, but I want them in
alphabetical order. Is there a quick way I can do this by selecting all
sheets and then sorting, or do I really have to go into each one and do
it manually?