Data Validation on Pasted Values in Excel

[grnzbra]

I have set size limits on some fields using Data Validation. This works fine when a value is typed in, but if the value is pasted in this doesn't seem to work. Is there a way to make the Data Validation rules apply to pasted values as well as those typed in?
(Or is there a way to prevent values from being pasted into a workbook?)

 

[combo]

Data validation fires when cell is edited. A partial solution may be clearing office clipboard with VBA when a cell with DV is selected:

Private Sub Worksheet_SelectionChange(ByVal Target As Range) 
  If Not Intersect(Target, CellWithDV_Reference) Is Nothing Then
    Application.CutCopyMode = False
  End If
End Sub

May be unpleasant when user copy something, select cell with DV and does not plan to paste.

An alternative Worksheet_Change event procedure requires duplicating DV limits rules in VBA. Hovever, in this case DV can be used only to display entry messages, Application.Undo will take back last user action if value entered/copied is outside permitted range.

combo

 

[grnzbra]

Thank you. I will try it.