Here is a link to an article on catching the paste operation that might give you some ideas:

http://www.jkp-ads.com/articles/catchpaste.asp

I was also involved in an discussion on the subject of preserving validation about a year ago. You will find it here:

http://www.dailydoseofexcel.com/arch...te-operations/