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

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

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

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


--
Ivan F Moala


------------------------------------------------------------------------
Ivan F Moala's Profile: http://www.excelforum.com/member.php...fo&userid=1954
View this thread: http://www.excelforum.com/showthread...hreadid=268394