Event in current sheet
 

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.

Event in current sheet
 

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.