Sort worksheet by color and then by name

[forest18]

Hi,

I would like to sort my worksheet according to colors then by name. How can I do this? I have the VBA code to sort my worksheet by colors.

Please Login or Register  to view this content.

Thanks in advance for your help.

[protonLeah]

The attached workbook adds a new sheet "workspace"
columns A:B hold - tab color:tab name
They are sorted by color code, then by name
the sheets are moved after "workspace" in reverse order
workspace is deleted

[forest18]

Hi ProtonLeah,

Thank you for your prompt reply. I have tried to create a new workbook but it doesn't seems working. I am pretty sure it's my problem as I am not really good in IT. Do you mind to take a look at my workbook?

Many thanks.

[jindon]

Build the code when almost identical question was asked...

Please Login or Register  to view this content.

[protonLeah]

In the worksheet you posted, you have a module named Reorder containing a sub also named reorder. Easiest fix is to rename the module, or just leave it as Module2 or whatever it was. You can't have a module and a procedure with the same name, VB won't know which one to use.