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

  • Thread starter Thread starter andrewLLL
  • Start date Start date
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
 
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
 
Back
Top