Jason Morin wrote...
To help prevent accidential copying and pasting over Validation cells, you
could
employ this technique from J. Walkenbach:

http://j-walk.com/ss/excel/tips/tip98.htm
....

Not reliable. At least not for XL97.

Given the setup in this tip, define validation as whole numbers between 0
and 10. Enter -500. Excel will display a dialog about the invalid entry.
Click the Retry button (or press [Enter]), then press [Ctrl]+C, [Esc],
[Ctrl]+V in sequence. Voila - there's an invalid entry in the cell that the
wonderful Change event handler did squat all to prevent. Pasting *text* into
cells leaves validation rules as-is, though completely ignored. This is also
true for pasting special as values. Excel's Data Validation is a toy feature
providing no more true security than worksheet or workbook protection
passwords.

The only *SECURE* way to implement validation involves both using Calculate
event handlers and hardcoding the validation rules within them to provide
entry-time validation, *and* using formulas, possibly in defined names, to
check all critical cells and return error values if there are any invalid
entries or innocuous values if all cells contain valid entries. Then use
those check values in all downstream calculations to ensure that *ANY*
invalid entries result in *ALL* downstream formulas returning error values.
*NOTHING* gets users to clean up their entries quicker than giving them
NOTHING BUT GARBAGE if they're careless or worse.