Is it possible to prevent users using Cut and Paste, as
the calculating cells (changing relatively)then use the
wrong cells. No problem copy and paste.

I have already used
Application.CellDragAndDrop = False
which prevents accidental use but would like to "turn off"
all Cut options, temporarily whilst this workbook is open.?

Suggestions Appreciated.

Paul Moles

Jim Rech provides one solution here that seems to be fairly
comprehensive.

http://www.google.com/groups?hl=en&l...8e19812&rnum=2

If you browse through other threads, you'll find many reasons why you
might want to consider another strategy.

http://www.google.com/groups?as_q=di...n&num=50&hl=en

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

Is it possible to prevent users using Cut and Paste, as
the calculating cells (changing relatively)then use the
wrong cells. No problem copy and paste.

I have already used
Application.CellDragAndDrop = False
which prevents accidental use but would like to "turn off"
all Cut options, temporarily whilst this workbook is open.?

Suggestions Appreciated.

Paul Moles

Never had Cut & Paste options, was trying to cut & paste application on net. Couldn't do it. Why isn't it a good thing to have.