XLS Padlock Guide
XLS Padlock Guide

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.