So I found this bit of code but it seems to be global and then it 'activates' on a single click rather than the Cntrl+V command.
Any tips on how to simply restrict copy/paste when the user issues the Control+V command?
Any tips on how to simply restrict copy/paste when the user issues the Control+V command?
VBA Code:
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
On Error Resume Next
Target.PasteSpecial xlPasteValues
Application.CutCopyMode = True
End Sub