I have a workbook where each worksheet name is the name of an employees
(surname & initial), total of around 50 different names.

Is there a quick way to sort the sheets into alphabetical order or does it
need to be done manually?

TIA

--
Jan

You can do it with code. Check out this web page
http://www.cpearson.com/excel/sortws.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mate" wrote in message
...
I have a workbook where each worksheet name is the name of an employees
(surname & initial), total of around 50 different names.

Is there a quick way to sort the sheets into alphabetical order or does
it
need to be done manually?

TIA

--
Jan

Works great, thanks very much.


"Bob Phillips" wrote in message
...

You can do it with code. Check out this web page
http://www.cpearson.com/excel/sortws.htm

--

I have a workbook where each worksheet name is the name of an employees
(surname & initial), total of around 50 different names.

Is there a quick way to sort the sheets into alphabetical order or does
it
need to be done manually?

TIA

--
Jan