Active Workbook event detection from a general purpose ADDIN
Hi again,
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,
Robert
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,
Robert
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Rory Archibald
PS The event handling code all goes in the add-in.