Modifying Ribbon via XLAM

[steven_b46]

I have an old Excel 2003 xla file that has some macros that are needed for some files, this used a custom toolbar. I attach the add-in upon opening the excel remotely from Visual Basic. This works fine in every Excel version up to 2010. The custom toolbar doesn't show in 2016 (and probably 2013). I googled this and it said to close all documents and reopen, that didn't work. I was thinking of creating a custom ribbon, but I am not sure how to attach it. I created a ribbon, and saved the XLAM file, but the ribbon appears to always be on. I was hoping I could dynamically turn this on/off by loading an add-in or via some macro or something. I appreciate any guidance.

[quekbc]

To show / hide a ribbon via macro, you'll need to use the GetVisible call back. Depending on how and which ribbon you want to show / hide, you need to create the callback for it.

For example, in customUI you have a tab that says

Please Login or Register  to view this content.

and in the workbook macro you would have something like

Please Login or Register  to view this content.

Perhaps going through this http://www.rondebruin.nl/win/s2/win012.htm would help.