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]

"Jim Thomlinson" wrote in message
...
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?

http://www.excelforum.com/archive/in.../t-229810.html

/Fredrik

Hi Jim,

Jim Thomlinson wrote:
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?

I don't know about denying the user from copying values in from another app,
but as Fredrik suggested, you can use Application.CellDragAndDrop = False to
prohibit users from copying down, filling, dragging cells, etc.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]