Remove Cut & Paste Options

[Paul Moles]

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

 

[pfsardella]

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

http://www.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&safe=off&th=112b0798a8e19812&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=d...F-8&as_ugroup=*excel*&lr=lang_en&num=50&hl=en

HTH
Paul

 

[Guest]

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.