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???).

MABeatty wrote:

That will not work. When you change the value that the "protected" cell
is referencing, the value in the "protected" cell needs to change. If
the cell is protected it will not allow that value to be updated.

--
MABeatty
------------------------------------------------------------------------
MABeatty's Profile: http://www.excelforum.com/member.php...o&userid=32258
View this thread: http://www.excelforum.com/showthread...hreadid=525349

--

Dave Peterson