How do I arrange worksheet tabs In alpha order

[Worksheet order]

I have multiple worksheets in an Excel File and it would be easier to work
with them if I could arrange them alphabetically without individually moving
them around everytime I add a new worksheet. Is there anyway in Excel I can
group them and arrange them to a specified order?

[Ron de Bruin]

Hi

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Worksheet order" <Worksheet [email protected]> wrote in message
news:[email protected]...
>I have multiple worksheets in an Excel File and it would be easier to work
> with them if I could arrange them alphabetically without individually moving
> them around everytime I add a new worksheet. Is there anyway in Excel I can
> group them and arrange them to a specified order?

[Anne Troy]

Here you go:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=72
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Worksheet order" <Worksheet [email protected]> wrote in
message news:[email protected]...
> I have multiple worksheets in an Excel File and it would be easier to work
> with them if I could arrange them alphabetically without individually
moving
> them around everytime I add a new worksheet. Is there anyway in Excel I
can
> group them and arrange them to a specified order?