ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   WorkbookOpen event unpredictable (https://www.excelbanter.com/excel-programming/310711-workbookopen-event-unpredictable.html)

JT[_5_]

WorkbookOpen event unpredictable
 
Have any of you come across a problem with Excel whereby if you have 2
different COM addins (VB6 code implementing the IDTExtensibility2
interface) that both subscribe to the WorkbookOpen event, then firing
the sink of this event is unpredictable.

e.g. 2 COM addins X & Y both subscribe to the WorkbookOpen event. A
Workbook referencing Addin X is opened, but does not have
its event trap for WorkbookOpen fired.

Any thoughts / work arounds ?


All times are GMT +1. The time now is 07:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com