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!