macro to select worksheet based on tab color

[drewbizz]

Hi can anyone help me create a macro that selects all worksheet tabs of a particular color. For instance, if i am selecting a worksheet that the tab is colored red, what is the vba code to select all red tabs in the workbook?

[john55]

just try...

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

[JieJenn]

replace the number with your own color number

Please Login or Register  to view this content.

You can find out about the tab color by using

Please Login or Register  to view this content.

[drewbizz]

What if I want the macro to be written so that if I click on a tab of any color all tabs of that color.in the workbook are selected. Thx for ur help:D

[JieJenn]

In that case put this in your workbook module. I use a conditional check box to turn on/off macro. In my case, if worksheet macro on and off range A1 = True then macro is active, if A1= False then macro is inactive.

Anyone know why I am having issue with checkbox active x control? If I use checkbox as a conditional check if won't let me go into Design mode unless I select other tab first.

Please Login or Register  to view this content.