How to put sheets in alphabet order inside a workbook

Eternity · Jan 16, 2004

Is there a possibility to put sheets inside of a workbook in alphabet order?
I can't find that anywhere. It would be quite useful if one would have a
large number of sheets named after different people.

Thanks!

Norman Harker · Jan 16, 2004

Hi Eternity!

See:
Chip Pearson:
http://www.cpearson.com/excel/sortws.htm

Code there that does it including option of upwards and downwards.

With that tag you must be in Sydney!
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.