Peter,
You need to use Application level events. See
www.cpearson.com/excel/appevent.htm for details.
"Peter Wallin" wrote in message
m...
Hello,
I have an add-in in Excel. Now, I want to run some code in my
add-in
when the user clicks in the current workbook. I want be able to
catch
when the user clicks in any sheet in any workbook. And then I
want to
handle that click event by running code in my add-in. How do I
that?
Thanks in advance, Peter W.