Sorting Worksheets?

[Mr B]

Is there any way to sort the Worksheets in an Excel file? Just standard alphabetical order is all I want. Or do I have to drag them all around manually?

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/sortws.htm
for some code to do your sorting

 

[Ron de Bruin]

Check out Chip's example
http://www.cpearson.com/excel/sortws.htm

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)

Is there any way to sort the Worksheets in an Excel file? Just standard alphabetical order is all I want. Or do I have to

drag them all around manually?