Is there a way to prevent pasting data into an Excel worksheet?
Elkar wrote...
....
Private Sub Workbook_Activate()
Application.CutCopyMode = None
End Sub
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
ByVal Target As Range)
Application.CutCopyMode = None
End Sub
....
Aside from the incorrect keyword None (it should be False), this won't
prevent PASTING into Excel from other applications. But maybe it'd
solve the OP's problem.
|