Hi,

I am creating and Excel where I want to prevent users to replace contents when using Drag and Drop. I have the following idea but I don't know how to program it.

If I Drag and Drop some Cells to another position where there is already something I become the Excel alert: "Do you want to replace the contents of the destination cells?" And the options Ok and Cancel.

Is there any way to program excel to always answer "Cancel" automatically so the user do not see the alert and has no option to replace the text.

Please take the following considerations in account:

Application.DisplayAlerts = False is not an option, because there are other messages that I want to see, and moreover this always will select ok as default
Application.CellDragAndDrop = False is neither and option, because there are other parts of the excel where I still want to use this option

Any suggestions?
Best regards