Hey guys,
I'm trying to customize a custom ribbon in Excel using VBA, but I can't find a way to change the names of the buttons.
I created the custom ribbon using the Office RibbonX Editor and I'm able to access it and make changes through the XML code, but I would like to be able to do it through VBA. Is there a way to do this without always having to go into the XML code?
I asked the chatbot assistant (Openai), and it says that it's possible,
it says that this code could work, but I don't know how to adapted to my ribbon
Sub ChangeButtonName()
'Select Button1
Application.CommandBars("Ribbon").Controls("Button1").Caption = "New name"
End Sub
the index of CommandBars, it supposed to be the name of my ribbon in XML? the label name of the tab? The id?
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" onLoad="OnRibbonLoad">
<ribbon>
<tabs>
<tab id="tab0" label="Ribbon Name??">
if anyone knows about it, I'll really appreaciate so much
Thanks in advance for any help!
Bookmarks