View Full Version : Disable Drag & Drop/Cut & Paste on worksheet

03-08-2010, 09:54 AM
I have a data entry area on ea row of my worksheet--formulas that correspond to entries are protected; all works fine until user takes the data and cuts/pastes or drags/drops it to another row. This causes cell ref errors in the protected area. How can I eliminate the drag/drop and cut/paste function on a worksheet. I tried a macro, but it does not compile when I click run. Any suggestions would be appreciated.

03-08-2010, 10:09 AM
You seem to want to leave copy in place. Don't know much about this but there is a discussion here: