Hi Kiara

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

--
Regards

Roger Govier


"Kiara Parker" <Kiara 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)