Preserve validation from copy/paste

[HPotter]

Hi,

I have a excel file where I have validations on columns A, B and C. Each column has different validation. How do I preserve them from copy/paste values. In column A, it is customer validation where I am enforcing unique value and it should start with letters SH. In column B, it is list validation. And in column C, I am enforcing to start values with CA.
Can someone provide VBA code to preserve the validation when someone tries to use copy/paste.
Thanks!

 

[Joe4]

How about just disabling Copy/Paste?
See: Disable copy paste function without VBA code

 

[HPotter]

How about just disabling Copy/Paste?
See: Disable copy paste function without VBA code

I tried following the steps but it is still letting the copy/paste function. Plus, this solution as it says only for dropdown values. I want solution for column where I am using other custom validations. Isn't there any solution using VBA code?