Thursday, September 10, 2015 – Permalink –
Worksheets can be dragged and dropped into any order required. They can be set up in numeric or alpha order, but doing it by hand is a bother.
Chip Pearson has written some macros that will do the job for you:
Here's the code to sort by tab color:
Sorting Worksheets In A Workbook
(The colorindex variable chooses one of the 56 colors in Excel's basic palette.
Here are all the colors and numbers as compiled by F. David McRitchie:Excel Colors )
See all Topics excel
<Doug Klippert@ 3:26 AM
Comments: Post a Comment