NON FUNCTIONING OF AUTO DRAG
- Thread starter N AYYAPAN
- Start date
Jack
Member
Hello
This is a very common problem for me, I am not sure if one of my macros or add ins that turns off my Drag and Drop. I suspect it's a macro I use to turn off copy/cut/paste functionality to protect a roster that relies on data validation a lot. So I have this simple macro that you can copy into a module in say your personal.xls and attach it to say the keystrokes ALT F or whatever and it makes this a very minor nuisance for me.
Sub AllowDragDrop()
Application.CellDragAndDrop = True
End Sub
Cheers
John
This is a very common problem for me, I am not sure if one of my macros or add ins that turns off my Drag and Drop. I suspect it's a macro I use to turn off copy/cut/paste functionality to protect a roster that relies on data validation a lot. So I have this simple macro that you can copy into a module in say your personal.xls and attach it to say the keystrokes ALT F or whatever and it makes this a very minor nuisance for me.
Sub AllowDragDrop()
Application.CellDragAndDrop = True
End Sub
Cheers
John