I have an addin that "presides" over all other Workbooks that get opened within the Excel application.
From within the ADDIN, I want to detect if the Active Workbook has either:
1) Changed the Activesheet or Tab
2) Issued a Save or Save As command
3) Issued a Close command.
Basically, I want the Activeworkbook (that doesn't know about the ADDIN's presence or else I would embed code) to tell the ADDIN what it is doing.
Is this possible without making any amendments to the Active Workbook?
Kind regards and thanks,