Protecting "linked cells"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using checkboxes on a spreadsheet "linked" to other cells on that sheet
that have "IF" statements in them. If a checkbox is manually checked, the
"IF" statement in the linked cell disapears and TRUE or FALSE appears in that
cell. Is there a way I can lock or protect the linked cell?
 
You're seeing exactly what it means for a cell to be linked to a
checkbox - i.e., it receives the value of the checkbox.

If you want the formula in the cell, what is the purpose of the linked
checkbox?
 

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

Similar Threads

linked cell to change another cell 5
Forms Checkbox & Protection - Excel 2003 2
Excel - randomly locking cells? 6
Unlink cells- how? 0
Cell Protect 1
Checkbox name linked to a cell 5
Form Checkboxes are not maintaining cell link 8
Trying to unprotect Checkboxes 2

Back
Top