Prevent Drag & Drop

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
 
B

Bob Umlas

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

Guest

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


„DaveyC4S†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Locked cells are still able to be selected with proper protection 1
protect formulas in locked cells from changing if data is moved 3
Protection 1
How to prevent users from changing cell format 1
How to change format protection default to unlocked? 2
Excel 2000 help please - Cell protection 2
Locked Several Worksheets, allow format cells/select unlocked cell 2
Enabling Autofilter and Sorting in a Protected Sheet 2

Top