Again, you need a macro:

Sub UnCheck()
Dim Obj As OLEObject
For Each Obj In ActiveSheet.OLEObjects
If Obj.progID = "Forms.CheckBox.1" Then
Obj.Object.Value = False
End If
Next
End Sub



--
Jim
"SLKoelker" wrote in message
...
| THANKS!!! it worked great.
|
| Just one more thing, is there a way to uncheck all the checkboxes at once
| instead of individually? Please help. Thanks.
|
| "Jim Rech" wrote:
|
| Usually you use option buttons for mutually exclusive choices like you
have.
| Anyway, you need to attach a macro to your option button/check box.
Double
| click it in Design Mode (settable in the Control Toolbox toolbar) and
paste
| code into the sheet module similar to this:
|
| Private Sub OptionButton1_Click()
| Worksheets("Sheet3").Activate
| End Sub
|
|
| --
| Jim
| "SLKoelker" wrote in message
| ...
| |I have a checklist in excel. For each question the person filling it
out
| must
| | choose Yes No or NA (all checkboxes created from Control Toolbox). For
all
| NA
| | answers the person must give a reason on sheet 3 that I renamed NA
| | Clarification. Is there a way to make it so that when someone checks
the
| box
| | for NA it automatically goes to the NA Clarification sheet (sheet 3)?
I
| don't
| | know if there is a hyperlink or formula I can put in for that? Please
| help.
| | Thanks in advance.
|
|
|