| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disabling Drag And Drop Referencing | New Users to Excel | |||
| Help please simple drop and drag I can't make work | Excel Worksheet Functions | |||
| cell drop and drag | Excel Worksheet Functions | |||
| drag and drop to get a lot of wordarts? | Excel Discussion (Misc queries) | |||
| drag and drop to get a lot of wordarts? | Excel Discussion (Misc queries) | |||
Threaded Mode
