Remove Cut & Paste Options
 

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

Remove Cut & Paste Options
 

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

Remove Cut & Paste Options
 

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.