I'm afraid I haven't clue how to answer your question.
Only responding because a) it's been hanging around, and
b) your OP is close to one I posted to which someone has
been good enough to answer (namely Tom Ogilvy).

So, my suggestion is to elaborate on your ultimate
objective.
Eg why do you want to automate Worksheet drag & drop. If
it’s about move/copy ranges with mouse, events would be
triggered on select and change if you need to trap these.
Or maybe it concerns move/resize objects. Hopefully if you
explain a little more someone far more expert might
suggest an alternative approach.

Good luck,
Dan

-----Original Message-----
Hello;

I have been looking for a solution that will enabled the
automation of drag-and-drop functionality for worksheet
ranges.

I have been looking at the different events which the
application and worksheet objects expose but they are not
workable for what I need to do.

I've also looked at windows api functions that may help
but the problem here is that one still needs a triggering
mechanism for these to work. Only fall back is, again,
the
application and worksheet events, which are not workable.

I wonder if there is a way to create a user defined event
and somehow hook it up to the app so that it recognizes
it?

Perhaps is there a way to register events with the app
via
the registry or some other method?

Thanks in advance for your help and/or suggestions.


.