Excel - Sheet Tabs

Asked By Michell on 02-Apr-08 11:23 AM
Can anyone tell me if you can alphabetize sheet tabs within a workbook?




Cimjet replied on 02-Apr-08 12:12 PM
Hi Michelle
I am not to sure if this is what you want, you can rename then by double
clicking on the tab but you will have to sort them by hand if need to change
the order.
Regards
Cimjet
Dave Peterson replied on 02-Apr-08 12:28 PM
You could run a macro:

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

David McRitchie's:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#sortallsheets

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


--

Dave Peterson