sorting worksheets alphabetically

[Joey]

If anyone can tell me how to sort worksheet tabs
alphabetically I would greatly appreciate it. I have
tried all I know and used the assistant but no help. All
I am trying to do is have all the worksheets sorted
alphabetically within the Excel file.
Thanks,
Joey
email: hend4471(remove this for spam reasons)
@bellsouth.net

 

[Paul B]

Joey, have a look here for some code to do it

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

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

 

[pfsardella]

Joey,

You'll probably need to create a macro to do this with reasonable
efficiency.

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

If you know little or nothing about macros,

http://www.mvps.org/dmcritchie/excel/getstarted.htm#havemacro

HTH
Paul