That is nice code. I have used similar. The problem that I ran into was
things being pasted in from applications other than excel, or where the users
where dragging or filling down. Any easy fix for those?
"Jake Marx" wrote:
Hi Tim,
Tim wrote:
How do I disable the copy paste feature?
You could try disabling all the places copy/cut/paste appear in the menus
(including context menus), but you'd still have to deal with other ways
people can copy/paste (Ctrl+c, Ctrl+x, Ctrl+v, etc). So maybe the easiest
way is to put the following code behind the Worksheet(s) you wish to disable
pasting:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.CutCopyMode = False
End Sub
This will allow the user to copy or cut, but every time the selection is
changed to a new cell or range, the clipboard will be cleared.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]