Change Check Box Colors in Column

[dcharmatz]

I used Doug Robins code to change the color of a checkbox color to
red:

With ActiveDocument
..Unprotect
With .FormFields("Check2")
If .CheckBox.Value = True Then
..Range.Font.Color = wdColorRed
Else
..Range.Font.Color = wdColorAutomatic
End If
End With
..Protect wdAllowOnlyFormFields, NoReset
End With

My question is... Do I have to go through and bookmark each Checkbox?
I have a table with a column for 'Yes' and 'No' that has a lot of
questions. Is there a way to say anything in the 'No' column calls
the code above (to flag it in red)?

Thanks,

David

 

[Doug Robbins - Word MVP]

Using a macro containing the following code on exit from each checkbox will
make the desired change. That is, you only need the one macro and it does
not matter what bookmark name is assigned to the checkbox.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP