Check boxes in a form not working

[Diane]

A user has a spreadsheet in which he has added checkboxes
by drawing them in design mode and resizing to cover a
cell. Then exits design mode and they work OK. When he
protects the worksheet the check boxes are protected too.
He has unlocked the control of the boxes but it still
doesn't work, does he need to create the checkboxes in
another way? What is he doing wrong?

thanks in advance

Diane

 

[Dave Peterson]

It sounds like he used the checkboxes from the control toolbox toolbar.

Have him try this:
(unprotect the sheet)
Go back into design mode
rightclick on the checkbox and show its properties
Look for the linkedcell.

Back to the worksheet itself--is that linked cell locked.

If the linkedcell is locked on a protected worksheet, he'll have trouble.

(you can unlock a cell via format|cells|protection tab.)