Prevent user to drag and drop
 

I would like to prevent users to drag and drop data.
Please note that I cannot protect the cells because I
want the user to be able to change the data, but drag and
drop mess up all my references.
Any idea?

Prevent user to drag and drop
 

This is a setting in ToolsOptions
You can change it with VBA

You can copy this two events in the ThisWorkbook module

Private Sub Workbook_Activate()
Application.CellDragAndDrop = False
End Sub

Private Sub Workbook_Deactivate()
Application.CellDragAndDrop = True
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"CVincent" wrote in message ...
I would like to prevent users to drag and drop data.
Please note that I cannot protect the cells because I
want the user to be able to change the data, but drag and
drop mess up all my references.
Any idea?

Prevent user to drag and drop
 

Great. Thanks exactly what I needed.
-----Original Message-----
This is a setting in ToolsOptions
You can change it with VBA

You can copy this two events in the ThisWorkbook module

Private Sub Workbook_Activate()
Application.CellDragAndDrop = False
End Sub

Private Sub Workbook_Deactivate()
Application.CellDragAndDrop = True
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"CVincent" wrote in message
...
I would like to prevent users to drag and drop data.
Please note that I cannot protect the cells because I
want the user to be able to change the data, but drag
and
drop mess up all my references.
Any idea?


.