Can I setup cells in a worksheet to accept data from a different
location using formuals and then prevent users from directly entering
data into those same cells. I wan the cells to receive the data from
the formula, but prevent users from directly entering data to that
cell....

my example is cell b3 gets data sum from cells b12thru i12 using a
formula embedded in b3) I want to prevent someone from just
accidentily entering data in b3 instead of the associated cells (b12
thru i12) thus preventing someone from eliminating the formula in
place (in b3) and cause problems with the rest of my sheets.

tks, if you have an answer

ratt out


--
ratt
------------------------------------------------------------------------
ratt's Profile: http://www.excelforum.com/member.php...o&userid=24318
View this thread: http://www.excelforum.com/showthread...hreadid=379229