Addin working on all sheets
 

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

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