I have data validation applied to a cell (e.g. A1) where the value of A1 can't be less than 1. However, the user goes around this by merely pasting the data in. How can I stop this and other attempts from destroying the integrity of my data? Is there something I can do after I install data validation so that someone doesn't easily get around it?
Bookmarks