Everything is working fine, however, I would like to prevent my users from
Cutting and Pasting only. If they Copy and Paste it's okay. If they Cut and
Paste the change lots of formula's in the backgropund of my workbooks. Any
idears?

Regards,

Henk


"Jake Marx" wrote:

Tim,

Tim wrote:
How do I do that??

Right-click the worksheet you want to apply this to and select "View Code".
Paste the code below into the resulting code pane.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

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


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]