Event in current sheet

[Peter Wallin]

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.

 

[Chip Pearson]

Peter,

You need to use Application level events. See
www.cpearson.com/excel/appevent.htm for details.