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