How to catch Drag-and-drop in Excel 97?

A

andrewLLL

Hello,

How to catch Drag-and-drop behavior (to move a cell)
specifically in Excel 97? Event Worksheet_Change is not
good enough since it is catching too many things. I want
something (an event, or a commandbar, etc.) which is
specifically responsible for Drag-and-drop (holding or not
the CTRL key). Thanks.

Andrew
 
I

Ivan F Moala

Hi Andrew

I'm not sure that you can ?? (or a least I haven't really looked into
it) but
If it is your intention to just disable it then just set

Application.CellDragAndDrop = False
 

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

Excel Drag and Drop 2
How to handle objects drag-drop? (Excel 2007 + VS 2008) 6
Catch drop event in excel 1
Drag/drop from TreeView (not in ActionsPane) to Excel Worksheet ? 1
Drag and Drop in user forms 3
Drag and drop from a Windows Form To Excel Worksheet 1
Drag and drop text in userform text / combo boxes 1
Outlook How to fire Drag and Drop event of outlook appointment using C#? 3

Top