I have a complex (I think) customized Department Menu system with RibbonX and various code that was designed separately for two different tasks that I am now working to try and combine. Both work fine separately, but I can't seem to get the two working together. The RibbonX and code all resides in the CustomUI of the Addin that loads when Excel starts.
The first 'task' was in setting up the RibbonX and code that when a specific workbook is opened, that additional items in a Custom Tab would be shown. This works correctly using App_WorkbookActivate to refresh the ribbon when a specific workbook is used. That code to show the extra menu items looks like this:
Now, the second separate task was in having a button available on the Home tab where the user could choose a department menu system which loads a separate customized tab and menu for each department. This is also seems to work correctly with the below code. It will read a 0 or 1 from the Addin file for each department and then load its menu tab. (I got alot of help here with this part ) And I tried to add the above into the below, but I can't seem to get the workbook specific information to show up, which if/when correct will only add the extra menu items to 1 departments menu when a specific WP is open.
Bookmarks