ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Worksheet Tabs (https://www.excelbanter.com/excel-discussion-misc-queries/183702-worksheet-tabs.html)

Cheri

Worksheet Tabs
 
Is there a way to alphabetize the tabs on a multi-sheet workbook without
doing it manually?

Dave Peterson

Worksheet Tabs
 
You could run a macro:

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

David McRitchie's:
http://www.mvps.org/dmcritchie/excel...#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

Cheri wrote:

Is there a way to alphabetize the tabs on a multi-sheet workbook without
doing it manually?


--

Dave Peterson


All times are GMT +1. The time now is 02:30 PM.

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