checkboxes lose value in Excel

[Jeffrey W. Smith]

I have created checkboxes in Excel using both the Control
Toolbox Toolbar and the Forms Toolbar. Both methods,
though, allow me to check a maximum of two checkboxes and
when I click a third checkbox or move the cursor to
another cell, the checked (True) status of the checkbox
clears inappropriately. How can I get these checkboxes to
retain their values unless the user clears them? Thanks
for any help!!

 

[Dave Peterson]

I've never seen this. How did you assign your linked cells?

Do you have any macro code running in the background (worksheet events?) or
macros associated with the checkboxes?