Type "Data Validation" into Excel Help...and click on "troubleshooting
data validation"... you'll see:


Code:
--------------------
Copying, filling, and calculating by formula override my data validation.

Data validation is designed to display messages and prevent invalid entries only
when users type data directly in a cell. When data is copied, filled, or calculated
by a formula, the messages don't appear.
--------------------


The help file goes on to list several ways to disable copy/paste to
prevent this issue.

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=468024