Macro to sort tabs in a worksheet

[AnalystMH]

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

[biznez]

Please Login or Register  to view this content.

[biznez]

here's another approach

Please Login or Register  to view this content.

[AnalystMH]

thank you, I will test this out and reply with my feedback. Very much appreciated.

[biznez]

You are welcome

[AnalystMH]

Well, The SortWorkbook macro sorted them in ascending order, but I am looking more for a custom order. The SortSheets macro did not work. Is there a way I can sort them based on a predefined list?

[biznez]

Can you give me an example of custom order

[AnalystMH]

Yes, the order, from right to left is:

Controls
Comments
Overview
Global
...etc there is about 20 tabs