Trying to unprotect Checkboxes

G

Guest

I have a spreadsheet with 9 check boxes on it. I've protected the sheet, and
unchecked the Locked and Lock Text boxes under properties for the checkboxes.
I've also marked the cells over which the boxes sit as unlocked. However,
with the sheet protected, checking the boxes produces a dialog box stating
"The cell or chart you are trying to change is protected and therefore
read-only.", and then tells me to unprotect the sheet.

What am I missing here? Is there an additional step to making these
checkboxes usable while protecting the formulas elsewhere on the sheet?

Much appreciated for any help that anyone can offer. Thank you.
 
G

Guest

Are the checkboxes linked to cells that are protected? If so then you need to
unprotect those cells.
 
G

Guest

Jim,

Thank you very much. That was exactly the answer. Little disappointed I
couldn't have worked that out myself, but definitely appreciate the help.

Dan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top