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: http://www.excelforum.com/member.php...o&userid=32258
View this thread: http://www.excelforum.com/showthread...hreadid=525349