How do I arrange the worksheets in my workbook alphabetically?

[Kiara Parker]

I have a very large workbook, incorporating about 30 worksheets. I need to
arrange these alphabetically, but can not for ths life of my find the option
to do this. perhaps I am going mad, or perhaps it is not very clear, but I
really need some help with this! (Excel 2003)

 

[Roger Govier]

Hi Kiara

Chip Pearson has some great code at his site on how to achieve this.
http://www.cpearson.com/excel/sortws.htm

 

[Jim Cone]

The free Excel add-in "Excel Extras" will sort your workbook sheets.
(right-click any sheet tab and choose Sort Sheets)
It also has other helpful features. Comes with a Word.doc install/use file.
Download from ... http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA

"Kiara Parker"
wrote in message
I have a very large workbook, incorporating about 30 worksheets. I need to
arrange these alphabetically, but can not for ths life of my find the option
to do this. perhaps I am going mad, or perhaps it is not very clear, but I
really need some help with this! (Excel 2003)