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

"DaveyC4S" wrote in message
...
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 ToolsOptions but
this is not inherited in the workbook after closing.

Any help greatly appreciated

Dave