Addin working on all sheets

[Rune Pedersen]

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

 

[Tom Ogilvy]

Instantiate Application Level Events and use the Change event.

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