About me

Greetings,

I'm the Community Manager of a private community. Our CFO and I do a lot of work with excel and are often looking for ways to improve the performance of spreadsheets based on VBA and Modules. What brought me here today is to find a way to set the tab color of multiple worksheets based on the value of another worksheet. We have budget files with detailed budget worksheet for each account in the chart of accounts. Not all cost centers use all the accounts, so I want to set the tab color to red for those accounts that the cost center is using. We have an "x" in the chart of accounts worksheet for the accounts they use. So the idea is, if there is a x next to account 705, then the worksheet titled 705 would be set to red.

Cheers,
Ken