how do I alphabetize by sheets in excel 2000? Is there an auto-so.

[Keith 1]

Hi,
I am working with a class or school roster for kids and we are wanting to
alphabetize the sheets since for us each sheet has a name of a kid.

Is there a way to automatically have excel 2000 alphabetize by sheets?

thanks,
Keith

 

[Chip Pearson]

There is no built in way to do this. You need a VBA macro to sort
the sheets. See www.cpearson.com/excel/sortws.htm


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[swatsp0p]

Chip Pearson has tips for doing this on his web site:


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

Good Luc