software

I have a worksheet that uses a lookup to display a value. The worksheet
is used by multiple people and they are frequently changing the lookup
value. However occasioinaly they also change the formula that does the
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 the
lookup value it comes back with an error that you can't change the
value of a protected cell--
MABeatty
------------------------------------------------------------------------
MABeatty's Profile: www.excelforum.com/member.php...oamp;userid=32258
View this thread: www.excelforum.com/showthread...hreadid=525349Hi

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.

quot;MABeattyquot; gt; wrote in
message ...
gt;
gt; I have a worksheet that uses a lookup to display a value. The worksheet
gt; is used by multiple people and they are frequently changing the lookup
gt; value. However occasioinaly they also change the formula that does the
gt; look up. How do I protect the formula from being edited or deleted.
gt; I've tried protecting the cells, but when someone tries to edut the
gt; lookup value it comes back with an error that you can't change the
gt; value of a protected cell
gt;
gt;
gt; --
gt; MABeatty
gt; ------------------------------------------------------------------------
gt; MABeatty's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32258
gt; View this thread: www.excelforum.com/showthread...hreadid=525349
gt;

That will not work. When you change the value that the quot;protectedquot; cell
is referencing, the value in the quot;protectedquot; cell needs to change. If
the cell is protected it will not allow that value to be updated.--
MABeatty
------------------------------------------------------------------------
MABeatty's Profile: www.excelforum.com/member.php...oamp;userid=32258
View this thread: www.excelforum.com/showthread...hreadid=525349Locking 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:
gt;
gt; That will not work. When you change the value that the quot;protectedquot; cell
gt; is referencing, the value in the quot;protectedquot; cell needs to change. If
gt; the cell is protected it will not allow that value to be updated.
gt;
gt; --
gt; MABeatty
gt; ------------------------------------------------------------------------
gt; MABeatty's Profile: www.excelforum.com/member.php...oamp;userid=32258
gt; View this thread: www.excelforum.com/showthread...hreadid=525349

--

Dave Peterson