Excel Ribbon adding own tabs

Question

Adding ribbon controls seems strightforward enough, but how do I make it so that the extra tab I have only apears when I open a specific workbook.

I want it so that who ever opens the workbook will get the tabs, these tabs and buttons fire of the macros with in this one work book.

do you have to code this dynamicaly or is it possible to tie ribbon customiations to workbooks?

This link explains how to add a custom ribbon tab to a specific Excel file: rondebruin.nl/ribbon.htm Other options are available: in Excel 2010 I think you can dynamically add items to the ribbon using VBA. — Tim Williams

Pynner Pynner · Accepted Answer · 2011-10-20T03:09:18

I addition to the link tim provided (which explains in pretty good detail).

If you are more interested in getting somthing simple working, this handy tool will help build custom menus.