Disable Paste in Data Validation Cells (List) - Locked

[MaddenJMF]

Hey guys,

Learning more about VBA - This is my second post. I've done some searching but it's not taken me anywhere!
Code pasted below is simply blocking "Paste" function to any cells formatted with Data Validation.

Is there a way that I can add variables to the code below, so that pasting will be allowed if Data Validation rules are matched (and Alert Message upon no match)?

Thanks in advance for any input.

Please Login or Register  to view this content.

[6StringJazzer]

I have tested this. I tried to use a loop to test all cells that changed for a multi-cell paste, but needs more thinking because of the Undo. If you exit when Count > 1 then you are going to miss cases.

Please Login or Register  to view this content.