Hmm... true about pasting from other applications. I guess I haven't really
run into people copying from other apps to Excel, just Excel to Excel.

However, the keyword None works just fine for me at work (Excel 2003) and at
home (Excel XP). Are you using older version? Regardless, False works as
well though.



"Harlan Grove" wrote:

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.