-
Select tabs by color
Can we select tabs by the "Tab Color"? I have a workbook with several dozen tabs, and using a macro, I'd like to select only the "blue" tabs (or other color), and copy them to a new file.
I have the code to select everything and create a new file but...
What do you think?
-
Re: Select tabs by color
not a great way but an idea - turn on record a new macro and then change the color of a tab and look at what excel/vba does - this should point you in the right direction
-
Re: Select tabs by color
Moved to Office Development