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
Bookmarks