Custom Ribbon For Just One Workbook?

If I make a custom ribbon, adding whatever macros or commands I like, is it possible to have the tab for that ribbon show up only in that single workbook and not in other workbooks? I want to do several custom ribbons for several different workbooks and not have a whole series of extra tabs at the top of the page.

Hi there,

If you incorporate Ribbon XML into a workbook, the Ribbon defined by that XML is available only to that workbook (even if other workbooks are open in the same Excel session).

Customising the Ribbon by right-clicking on the Ribbon and selecting the "Customize the Ribbon . . ." option creates a Ribbon which applies to any Excel session and will therefore be visible to any workbook.

Regards,

Greg M

Hi. How do I incorporate Ribbon XML?

Hi again,

It's a whole new ballgame!

The following link might help to get you started:

https://www.rondebruin.nl/win/section2.htm

Regards,

Greg M

Thanks very much.

Hi Greg,

I know this is years old by now but I am wondering if there is any way to solve this article now since the link you have provided no longer works.

You can use waybackmachine to view the links

https://web.archive.org/web/20200819...n/section2.htm

Perfect thanks ByteMarks, I always forget about this option.