Data Validation - Ignored When Pasted

You will have to use VBA to disable pasting, but the effectiveness of this is entirely dependent on the user choosing to enable macros when the workbook is opened.

Here is one way to go about it and there is likely a better approach.
Use this code in the workbook activate event. It is simply used to select any cell not among those that include validation. Adjust cell reference as needed.

Please Login or Register  to view this content.

Use this code in the worksheet module. The worksheet activate event uses the same approach as the workbook activate.

The worksheet selectiion change event is used so that when the user selects any cell, the clipboard is cleared and there is nothing to copy. This code should be amended to target a specific range, but you didn't provide details on which cells are in view.

Please Login or Register  to view this content.