|
Subject:
|
Excel & RibbonX
|
|
Posted By:
|
LBAKER
|
Post Date:
|
8/13/2008 11:25:09 AM
|
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
|
|
