Drag and drop

  • Thread starter Roberto Bumbalo
  • Start date
R

Roberto Bumbalo

Hi I would like to know if there is a command to deselect "allow cells drag
and drop" check box, and how to integrate it on to a macro every time a file
is open.
 
R

Roger Govier

Hi

You could put this in an Auto_open macro

Sub Auto_Open()

Application.CellDragAndDrop = False

End Sub

You can copy the code posted and paste it into your Visual Basic Editor
(VBE) in a Standard Module located in your project (workbook). Shortcut
keys would be ..

Alt + F11 (open VBE)
Ctrl + R (open Project Explorer)
Select file on left
If no modules exist:
Insert | Module
Paste code in Module
If modules exist:
Double click desired module
Paste code in Module
Add further code if required.
 
Top