Protecting Formula's

  • Thread starter Thread starter MABeatty
  • Start date Start date
M

MABeatty

I have a worksheet that uses a lookup to display a value. The workshee
is used by multiple people and they are frequently changing the looku
value. However occasioinaly they also change the formula that does th
look up. How do I protect the formula from being edited or deleted.
I've tried protecting the cells, but when someone tries to edut th
lookup value it comes back with an error that you can't change th
value of a protected cel
 
Hi

You'll need to unlock (from Format/Cells/Protection) all of the cells and
then just lock the one you want protecting. Then protect the worksheet.

Andy.
 
That will not work. When you change the value that the "protected" cel
is referencing, the value in the "protected" cell needs to change. I
the cell is protected it will not allow that value to be updated
 
Locking the cell with the formula and protecting the worksheet won't affect the
way that formula works.

It will stop users from typing over the cell that's protected (just the cells
with the formulas???).
 
Back
Top