ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Sort Worksheet Tabs (https://www.excelbanter.com/excel-programming/382513-sort-worksheet-tabs.html)

BSII

Sort Worksheet Tabs
 
Does anyone know of a VBA command or program string to sort the worksheet tab
order? I have a program that divides up data into 10+ tabs and renames the
worksheets automatically. I'd then like to sort them alphabetically.

Thank you for any help you can offer.

merjet

Sort Worksheet Tabs
 
http://www.cpearson.com/excel/sortws.htm

Cheers,
Merjet


Doug Glancy

Sort Worksheet Tabs
 
http://www.cpearson.com/excel/sortws.htm

hth,

Doug

"BSII" wrote in message
...
Does anyone know of a VBA command or program string to sort the worksheet
tab
order? I have a program that divides up data into 10+ tabs and renames
the
worksheets automatically. I'd then like to sort them alphabetically.

Thank you for any help you can offer.




Jim Cone

Sort Worksheet Tabs
 
- or-
The free Excel add-in XL Extras will do that;
right-click a sheet tab and select sort. Download from...
http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA


"BSII"
wrote in message
Does anyone know of a VBA command or program string to sort the worksheet tab
order? I have a program that divides up data into 10+ tabs and renames the
worksheets automatically. I'd then like to sort them alphabetically.

Thank you for any help you can offer.

BSII

Sort Worksheet Tabs
 
Thanks everyone - works like a charm

"Jim Cone" wrote:

- or-
The free Excel add-in XL Extras will do that;
right-click a sheet tab and select sort. Download from...
http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA


"BSII"
wrote in message
Does anyone know of a VBA command or program string to sort the worksheet tab
order? I have a program that divides up data into 10+ tabs and renames the
worksheets automatically. I'd then like to sort them alphabetically.

Thank you for any help you can offer.



All times are GMT +1. The time now is 12:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com