I'm looking for a VBA solution that I can run for an entire workbook, which will change the tab color to an RGB value if it contains part of a name. I'm guessing this would be a separate module. There are two modules in my workbook already.
My tab names all end with three or two letters. Preceding them is a number and/or other text. But there are only 10 types of "names" I want to look for.
Examples of tab my names are "11 atOTT" or "8 vsTOR". I want to be able to set an RGB color for the tab if it contains "OTT" or "TOR" etc. Those are two of the 10 I would like to set.
Thanks.
Bookmarks