Hi Al007,

See John Walkenbach suggestions at:

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


---
Regards,
Norman



"al007" wrote in message
oups.com...
Is there any macro which will not allow users to paste in a range of
cells containing validation (data has to be input & not pasted)??
Thxs