Prevent Drag & Drop

D

DaveyC4S

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
 
B

Bob Umlas

Turn it off in VBA in the workbook_open event
You can record it to see the syntax.
 
S

Stefi

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


„DaveyC4S†ezt írta:
 
Top