order worksheets alphabetically???
 

Hi,

Is it possible to use a macro to order sheets alphabetically? Sounds
simple (much like myself!!)

Thanks guys and gals :-)


---
Message posted from http://www.ExcelForum.com/

order worksheets alphabetically???
 

There is no built-in way to do this. You need to use VBA code.
See www.cpearson.com/excel/sortws.htm for details.


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


"ali " wrote in message
...
Hi,

Is it possible to use a macro to order sheets alphabetically?
Sounds
simple (much like myself!!)

Thanks guys and gals :-)


---
Message posted from http://www.ExcelForum.com/

order worksheets alphabetically???
 

See Chip Pearson's page with sample code to do this:

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

--
Regards,
Tom Ogilvy


ali wrote in message
...
Hi,

Is it possible to use a macro to order sheets alphabetically? Sounds
simple (much like myself!!)

Thanks guys and gals :-)


---
Message posted from http://www.ExcelForum.com/

order worksheets alphabetically???
 

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"ali " wrote in message
...
Hi,

Is it possible to use a macro to order sheets alphabetically? Sounds
simple (much like myself!!)

Thanks guys and gals :-)


---
Message posted from http://www.ExcelForum.com/

order worksheets alphabetically???
 

There is an example how to do this in John Walkenbach's book "Excel
2002 with VBA". See his site.


"Niek Otten" wrote in message ...
http://www.cpearson.com/excel/sortws.htm

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"ali " wrote in message
...
Hi,

Is it possible to use a macro to order sheets alphabetically? Sounds
simple (much like myself!!)

Thanks guys and gals :-)


---
Message posted from http://www.ExcelForum.com/