Hi All,

I would like to use VBA to sort the tabs in my workbook. There are a couple ways I imagine this could be done. The first is sorting them based on their color, for example the black tab is first all the way to the right, and second is the blue tabs, then the green tabs, then the orange, and finally all the way to the left is the yellow tabs. The second way I can imagine doing this would be to sort by the tab name, (not alphabetical). For instance, all the way to the right would be "Controls", then one to the left would be "Summary".. etc This could be done by listing the sheet names somewhere and referencing that range in the code I believe.

Thanks for your help!,

MH