Change tab color with check boxes?

[bosswick]

I was wondering if it is at all possible to change the color of a tab (where the sheet # or sheet name is displayed) based off of if a checkbox is checked.
I currently have a successful action of placing an 'x' in the box, where it changes the color by using:

Please Login or Register  to view this content.

Essentially, once we start the list in cell A3, it colors the tab yellow - for our purpose indicating that it is in process.
Once I put an x in the last "All completed" Cell A96, it colors the tab gray indicating everything is completed on that tab, or in my particular case, that day.

I've tried linking the checkbox to particular cells and replacing the blank with FALSE and the "x" value to TRUE, but it doesn't seem to be changing the color... so I'm sure I'm doing something wrong as I don't have a whole lot of experience with VBA. Google has gotten a lot of results for changing colors of cells, but can't seem to find changing tab colors.

I know it may seem a bit redundant, since I already have a successful action with the x's. I am a trainer and compiling a day by day (sheet by sheet in this case) training checklist, and dont want to have to run back and forth to my keyboard to mark a x, when I can just have my wireless mouse to navigate and click the checkbox instead.

[Logit]

.
Paste this into the sheet module :

Please Login or Register  to view this content.

Color list : http://access-excel.tips/excel-vba-color-code-list/

[bosswick]

Hmmm... didn't appear to have any effect on the color of the tab when checking the box for me?
I removed my old script and just used that and also tried adding a new checkbox and adjusting the checkbox number in the script. :|

[Logit]

.
The macro requires you to have an ActiveX Checkbox on the sheet. Do not use a Userform Checkbox.

[bosswick]

Ah, that did the trick! Thank you!

[Logit]

.
You are welcome.