Re-ordering Worksheets

[Neil Pearce]

Dear all,

Is there a way to reorder worksheets without manually dragging them?
Ideally by alphabetical order.


Cheers,

Neil

 

[Jim Cone]

Yes, but it requires using vba code or an installing an add-in (third party utility)
--
Jim Cone
Portland, Oregon USA



"Neil Pearce" <[email protected]>
wrote in message
Dear all,
Is there a way to reorder worksheets without manually dragging them?
Ideally by alphabetical order.
Cheers,
Neil

 

[Dave Peterson]

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:

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.)