Solved: Clear check box on open

[austenr]

I have done this be for but have lost the code. I want to clear the contents of the check boxes in my worksheet on open but using
Range("A1:A4").ClearContents does not work. In fact I have tried ClearAll and it does not either. Any ideas? :dunno

[Bob Phillips]

Dim cb As CheckBox
For Each cb In ActiveSheet.CheckBoxes
cb.Value = False
Next cb

[austenr]

Knew it was something like that. Thanks

[alimcpill]

what's goin on here? if i type activesheet.Checkboxes in my immediate window, then highlight 'Checkboxes' and press F1, I received the following message:

Hidden Language Element

You have requested Help for a language element that is hidden, and therefore unavailable for programmatic access.

Have you been dabbling with the occult??