Sort worksheets within a file

[Ted Horsch]

I need to do an ascending sequence ordering of several
worksheets in a single workbook/file.

Example:

Worksheets tabs CF FG AA AB FG(2) AA(2) DA

I can click and drag, but is there a command or macro I
can use to have them sorted for me? Here's the desired
sort order for the worksheet tabs:

AA AA(2) AB CF DA FG FG(2)

I actually have about 50 worksheets in the file. I'm on
Office 2003 under W2Kpro.

Thanks,

Ted

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/sortws.htm

 

[Ted Horsch]

Frank,

Works like a charm. Thank you very much for your response.

Ted