Use VBA to select multiple worksheets based on tab color

[drewbny]

Is there a way you can select multiple worksheets based on tab color, or a way you can select which tabs you want to work with using a list? Using the traditional method of using control and click is too time consuming. Im not proficient in VBA and would like to know how this can be done.

 

[Ruddles]

Looks like it might well be! Do you just want hidden sheets ignored?

If so, amend the following line of code:-

    If ws.Tab.ColorIndex = wsColor(0) [COLOR=red][B]And ws.Visible = xlSheetVisible[/B][/COLOR] Then

 

[craigxl]

How can i modify this macro to select all of the sheets that have coloured tabs? (leaving all of the sheets with uncoloured tabs unselected)

 

[MARK858]

How can i modify this macro to select all of the sheets that have coloured tabs?

The code in post number 3 already does based on the Activesheets tab colour. So select a sheet with the tab colour (it only deals with one color).