I've posted a few times about Protection
(Please look here
Here's another very quick way to (partially) protect formulas.
Go to Data
and select Custom
from the Validation Criteria
dropdown box on the Settings
tab. Then enter the following into the Formula
Simple. If you try to overwrite the formula, an error message will appear like below (you can choose a different style on the Error Alert
So, what's happening here? Well, =""
means "equals nothing", so if you try to enter "something" an error will occur.
However, this is not 100% reliable as it won't prevent deletion by using the Back Space
Keys, and the cell can be removed by deleting the Row
At the same time, it will prevent accidental overwriting in most cases, so it's a good protection alternative to remember. It's easy to use and every little bit helps.
Posted by andrewe at 20:09
I like this solution and I used many times.
Usually I write an instruction for this.
"When you accidentally delete the contain of a cell, you can undo this with the edit/undo menuitem."
Otherwise the user cannot write back the original data.
Excellent idea Zoltan. The more detail shown, the easier for the user to understand!
I have tried your solution , but the moment I paste an invalid entry in the cell that conatins the validation , the cell accepts it.
Example:- I enter a validation in cell A5 that the number entered cannot be greater that cell C5, It shoots an error message when I type in a number greater than cell C5, but the moment I copy a number which is greater than cell C5 from a different location , the cell accepts it and the validation is over written.