How to disable drag and drop? |
To disable drag and drop operations for your Excel workbook, just add
Application.CellDragAndDrop = False
to the Workbook_Open VBA event, and forbid access to the VBA editor in XLS Padlock, so that customers cannot remove that line.