Re-ordering Worksheets
 

Dear all,

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


Cheers,

Neil

Re-ordering Worksheets
 

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



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

Re-ordering Worksheets
 

You could use a macro...

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

Neil Pearce wrote:

Dear all,

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

Cheers,

Neil

--

Dave Peterson