Protecting formulas

  • Thread starter Thread starter Shaunna
  • Start date Start date
S

Shaunna

Hello,
I've been working on a daily log for the guys that work with me. I was
wondering if there is a way to protect formulas in a cell. So if the guys hit
delete or such they will not delete the formula. So all my calculations will
be correct. But I still need it to where the guys can still add info in those
cells.
Thanks,
Shaunna
 
If you have a formula in the cell, and it is typed in, the formula would then
be removed. If you are OK with this, there is no way to allow the cell to be
typed in but not deleted.

If you want to protect/unprotect only certain cells, go to Format - cells -
Protection and select/deselect Locked. Then Go to Tools - Protection -
Protect sheet.
 

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

Protecting select cells 2
Inserting Picture Into Protected Worksheet 1
backing up formulas in sheet coding? 2
Using Defined Names in a Formula 1
IF Formula that results in Protection???? 7
Protect 2
Data Validation - Preventing Delete from Delete Key 2
how to protect cells? 4

Back
Top