Prevent Drag & Drop

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have produced a protected worksheet with a mixture of locked and unlocked
cells. I would like to prevent the ability to drag and drop unlocked cells
as a function of the worksheet. Currently it is possible to drag one
unlocked cell onto another.

I know the drag and drop function can be turned off in Tools>>Options but
this is not inherited in the workbook after closing.

Any help greatly appreciated

Dave
 
Put
Application.CellDragAndDrop = False
in Workbook_Open.
Regards,
Stefi


„DaveyC4S†ezt írta:
 
Back
Top