Excel 2007 : How to reload a Custom Ribbon using VBA

Excel Gurus,

I have a problem with Custom UI tabs.

I created two applications both of which have Custom Ribbon tabs. These two applications are meant to work simultaneously. If I am working on Application 1, I have to open the workbook of Application 2.

The issue is. Sometimes, when I close one of the applications (Say application 1), the tab is that is supposed to be on Application 2 is also dissapeared.

I tried several methods to fix this but not able to fix it. However, I want to provide a macro and insert the button in the welcome sheet. This macro is supposed to re-initiate the ribbon. I added this macro to the Add-ins.

Can you please help me with this code?

I attached samples of both the files. These are replicas of the main applications stripped down of all the information and possess dummy macros. (This is done due to the sensitivity of the information it holds.)

Application 1.xlsm
Application 2.xlsm

XML Code I used in the custom RibbonUI

Please Login or Register  to view this content.

Regards,
RK

PS: Posted the same in another forum as well. (http://www.ozgrid.com/forum/showthread.php?t=163613)