How to Control Drag and Drop? (force "shift" drag-drop, disable into certain rows)

Hi there,

thanks for your time. I have a sheet, and I have successfully controlled every possible shortcut - cut, copy, paste, insert. I have my own shortcut menu, and capture shortcut keys.

The one area I haven't controlled is drag and drop. I don't mind the users dragging and dropping a whole row, so long as it is a "shift" drag and drop which just moves rows. I don't want users to do a non-shift drag and drop which is an overwrite. I also don't want the destination to be in the first 2 rows, which are heading rows.

Is it possible to change all drag and drop operations to "shift" drag and drops, and disable drag and drop into the first 2 rows? Thanks for your help!!

Hi there,

I managed to accomplish controlling drag and drop now, but it was painful. It basically involves detecting it using a combination of Worksheet_Change and Worksheet_SelectionChange, then undoing the non-ctrl non-shift drag-drop or ctrl drag-drop, then mimicking the behavior using a cut and insert. However it is very slow, especially the undo part.

Is there a faster way? Thanks.