Charlie Hall
12-17-2009, 08:47 AM
Hi,
I have a 2003 Addin that I am adding a ribbon interface to. Having purchased the RibbonX book I am following chapter 16 on sharing and deploying. I have created a 2007 Addin that just has the ribbon and launching code. However, when I close the 2003 Addin, the 2007 Addin does not close.
Specicifically, in the 2003 Workbook_BeforeClose event, I call a routine that issues a Workbooks.close command of the 2007 Addin. If I call the routine via the Immediate window, the 2007 addin closes. But if I close the 2003 addin via the Immediate window (thisworkbook.close), the routine is called but the 2007 addin remains open.
Since my code is so similar to the code in the book I am having a hard time understanding why it does not work. I also stripped out the ribbon code, and the problem remains.
Any insight would be greatly appreciated.
Thanks
--Charlie
I have a 2003 Addin that I am adding a ribbon interface to. Having purchased the RibbonX book I am following chapter 16 on sharing and deploying. I have created a 2007 Addin that just has the ribbon and launching code. However, when I close the 2003 Addin, the 2007 Addin does not close.
Specicifically, in the 2003 Workbook_BeforeClose event, I call a routine that issues a Workbooks.close command of the 2007 Addin. If I call the routine via the Immediate window, the 2007 addin closes. But if I close the 2003 addin via the Immediate window (thisworkbook.close), the routine is called but the 2007 addin remains open.
Since my code is so similar to the code in the book I am having a hard time understanding why it does not work. I also stripped out the ribbon code, and the problem remains.
Any insight would be greatly appreciated.
Thanks
--Charlie