Protect Worksheet but still use option boxes

[jmilazzo]

Does anyone know how to protect a worksheet but still let option boxes and check boxes be selected?

I have two option boxes that each have a yes or no selection and one check box that I need to be able to select while the sheet is protected.

Thanks!!!
Jessie

 

[Mel L]

You have to unlock the boxes themselves. If you'll right click on the check box then click format control, click the protection tab and if the "locked" box is checked, uncheck it. This will allow you to protect your sheet but still make the check boxes available.

Mel

 

[Andrew Poulsom]

You need to unprotect the cells that are linked to the controls.