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

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

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


€žDaveyC4S€� ezt Ã*rta:

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