View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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.