use the selectionChange event

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.CutCopyMode = False
End Sub


of course if macros are disabled, then this won't help

--
Regards,
Tom Ogilvy


" wrote:

What I meant was when a person presses on the Paste icon or "CTRL-V",
instead of pasting like usual (i.e. with all formats etc), it will
only paste as text without any format.