Preventing Data Entry In A Cell
Posted by Trevor W on August 30, 2001 10:28 AM
I have cells in a workbook which contain formula results. (Example)C4 defined as A1+B2.The problem is that when other people use the file they overwrite the cell and the formula is lost. I have tried using data validation with the Custom option and entering the formula there but to no effect. I believe it is because the formulae entered there have to evaluate to true or false. I also tried using the protection feature but I only want to protect individual cells, not entire worksheets. What can I do to the cell prevent people from modifying cells after I have placed formulae in them? Any suggestions at all would be welcome.