Drag and drop

  • Thread starter Thread starter Roberto Bumbalo
  • Start date 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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Convert EML to PST? 2
copy and paste running total to another sheet 1
Drop-down list and error message 1
Drop Down List 2
Drag and drop 1
Drag-and-drop to Custom Task Pane 0
Data Validation and drop-down list using IF, AND and what else? 8
Outlook How to fire Drag and Drop event of outlook appointment using C#? 3

Back
Top