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.
