View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Addin working on all sheets

Instantiate Application Level Events and use the Change event.

http://www.cpearson.com/excel/AppEvent.htm
at Chip Pearson's site.

--
Regards,
Tom Ogilvy


"Rune Pedersen" wrote in message
...
How can i create a sub in an addin that responds when there is a change in

a
cell in any sheet in any workbook also outside the addins sheets