Making VBA add in available to all workbooks

I have writtem some VBA code that is attached to a sheet which reacts the a cell change:

Sub Worksheet_Change(ByVal target As Range)

However, I actually want to write an add in that will react to any cell change event regardless of the sheet or workbook (or excel file) worked on. Think of my add in as a logger that logs every cell change in excel (primarily in terms of value but other properties are fine too)

Any thoughts on how to achieve this?
Thanks,
Raj

Although my initial plan is to just log each change to a file, eventually I would like to send the event to a server (hence I am looking for a way, be it VBA or some other excel API to be able to catch all events regardless of the workbook loaded such that I can convey changes to the files being edited to a remote location).

You can create an application event.
1)Insert a code module, use the properties window to change its name to appEvent, and put this code in it.

Please Login or Register  to view this content.

2) Put this in a normal code module

Please Login or Register  to view this content.

startUp needs to run to declare the application event, so this in ThisWorkbook

Please Login or Register  to view this content.

The your code will run whenever a cell is changed in any open workbook.