Worksheet name in order
 

Can someone tell me how to sort/arrange worksheets name in a order but
not by dragging sheet after sheet in ws tabs column.

It is possible to do in VBA.

Thank you.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Worksheet name in order
 

Michael,

See http://www.cpearson.com/excel/sortws.htm for example VBA code.


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



"Michael168" wrote in message
...

Can someone tell me how to sort/arrange worksheets name in a order but
not by dragging sheet after sheet in ws tabs column.

It is possible to do in VBA.

Thank you.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/