I have an Excel dictator application with all VBA isolated in its own workbook. Throughout the application, data workbooks are built/opened/viewed & modified by the user/closed (6 different workbooks at different times). I am having a problem putting the ribbon in a shared Namespace, such that it is entirely common between all workbooks with onAction events executing callbacks in the main VBA workbook.

I have gone through Excel 2007 VBA Programmers Reference -- Chapter 12 in detail, but am really struggling. With initial tests, once a data workbook is opened and active, none of the onAction events work. Also, it appears that all values for global variables are lost.

I want to have all ribbon customizations in an add-in which is programmatically installed during application initialized and de-installed upon application exit.

Any help would be sincerely appreciated.

Thanks.

Lenora Baker