Excel Ribbon Buttons

[ry94080]

Hi all,

I have a .xlsm file that I have created that works perfectly fine. I was hoping to setup some buttons on the Ribbon to access the different functions. After some research, it appears that the only way to do this is via CUSTOM UI?

My work doesn't really allow adding new programs and needs to go through an approval process.

Is there a way to add these buttons without Custom UI? I would like to share this .xlsm with other users, but with the buttons available.

Thanks!!

[sintek]

have a look at these links
http://stackoverflow.com/questions/8...-tab-using-vba
https://msdn.microsoft.com/en-us/lib...ffice.14).aspx
https://www.rondebruin.nl/win/s2/win003.htm

[ry94080]

Hi sintek,

Thanks for the reply. I think I'm on to something. I was able to add the buttons with the following syntax. What would be the syntax if I needed to add a second button on the same tab and group?

Please Login or Register  to view this content.

[sintek]

Sorry, not familiar with xml code for UI