One RibbonX for multiple Excel 2007 workbooks

Question

I have an Excel 2003 VBA solution I'm converting to Excel 2007. The solution had a large collection of menus that were used between multiple workbooks. I've created RibbonX to replicate this functionality, but now I'm to the point where I want to make my Ribbon show up on all these workbooks. How do I go about this? When I switch from one workbook to another the Ribbon disappears. This isn't a VSTO solution just to be clear it is straight Excel with VBA. I'm hopeful you don't have to put the RibbonX into each workbook.

score 1 · Accepted Answer · answered Oct 09 '10 at 18:52

1

You need to save it as an add-in (.xlam), which can then be added by other users. This will keep it visible for all workbooks.

answered Oct 09 '10 at 18:52

Diem

58
4

thanks I will try that when I get home tonight. From VBA is there anything special about disabling and enabling the ribbon whenit is an addin? – Cj Anderson Oct 09 '10 at 19:28
I should say controls on the ribbon. To be more specific. – Cj Anderson Oct 09 '10 at 19:29

One RibbonX for multiple Excel 2007 workbooks

1 Answers1