Highlight Text In Cell if Checkbox is Un-Checked

[dmartin55]

Greetings,

Currently I have Active X Control Check boxes where if the box is checked, the sheet will be displayed who's name matches the check box's caption. If the box is unchecked, the sheet becomes hidden. I want to add another layer to this where if the box is unchecked, then the linked cell's text will be a light grey (almost to where you can't see the name) to visually indicate (more so) that the sheet isn't being used.

Attached is a sample workbook that already has the code to hide the sheets when the checkboxes are unchecked.
The code is located in Sheet6(Checkboxes).

Existing Code for CheckBox1

Please Login or Register  to view this content.

[protonLeah]

One way:

Please Login or Register  to view this content.

[dmartin55]

One way:

Please Login or Register  to view this content.

Switched with statements. When box is unchecked, the text is grey and the sheet is hidden. Thanks!! Now to update 40 checkboxes...

Please Login or Register  to view this content.