Prevent copy and paste invalid data for data validation cells

That is the weakness of data validation - it is the same as any other cell. You can paste anything into the cell.

You could use VBA to prevent the user copying and pasting into data validation cells
(I assume you want the user to be able to use copy and paste in other cells)

You are repeating what you have already told us.

Do you want the user to be able to use copy and paste in other cells?

If you allow paste on cells with data validation but without dropdown, then Excel overwrites data validation
- do any of the cells have data validation without a dropdown?

Edit:
Just a thought ..
- are data validation cells in specific columns (without other data)?
- may be simpler to block paste in those specific columns

Thank you for the workbook - I will look at it tomorrow

test in attached workbook
data validation is in "yellow" cells

this code prevents: user selecting E4:F4 \ {CTRL} c \ click on B4 \ {CTRL} v
it does not prevent: user selecting E4:F4 \ {CTRL} c \ click on A4 \ {CTRL} v
I will try find a simple solution for that

in sheet module:

Please Login or Register  to view this content.

But, in here, it can be copied the text and paste it to the selected cell.

It means, when I copied only text and it can be pasted into selected cell.

Try more comprehensive solution in attached file

Thanks to @xladept and @sintek for their suggestions - see this thread


ThisWorkbook module:

Please Login or Register  to view this content.

SheetModule:

Please Login or Register  to view this content.

General Module:

Please Login or Register  to view this content.