Here is my "go-to" reference:
RibbonX: Customizing the Office Ribbon by Robert Martin, Ken Puls, and Teresa Hennig
Although written for Office 2007, it is still gold.

You need to name your macro as a ribbon control.
i.e. Sub btnNewStyleSets_Click(control As IRibbonControl)

Take a look at my Continuous Page Numbering Add-In which has a single button added to the header tab with an associated macro.
For a different example where none of the macros are triggered directly by Ribbon buttons but rather are triggered through QAT buttons, see Random Text Add-In.

Hi Charles. Thanks for responding. Not clear on the answer. Let me explain again.

I look at Style Manager by opening the customise ribbon and looking at all commands. I go down and hovering over the menu item, it tells me it is a macro.

At this point, I am not sure what I do with it. Since it tells me it is btnNewStyleSets_Click, do I have to add that as a sub to my VBA and write some code for it to open the Style Manager panel?

Apologies for asking such basic questions but I have spent a considerable time on Google without success. I did look at your example, but it seems to be a straight forward macro you wrote yourself, and I see how that works. I have a few VBA routines I have written on the toolbar, but cannot work out what I do with an inbuilt macro.

I think I have my head around commands, and running my own VBA routines, but not sure what to do with inbuilt Macros. Also thanks for the book reference.

If you are talking Ribbon Customization, you do NOT want to be messing with the Customize the Ribbon dialog if you want custom images.
Modifying the Ribbon in Microsoft Word
Customize the Ribbon (It doesn't take rocket science)
Below is the dialog you do not want to be using...
00 deleteme 3.png

Working on the XML produced by that dialog is way more trouble than it is worth, if it can even be done.

If you are customizing the QAT, on the other hand, the Customize the QAT dialog may well be the place to start, even if you are going to be modifying the XML directly at a later time.
Below is the similar dialog for modifying the QAT:
00 deleteme 2.png

Modifying the QAT in Microsoft Word


This is a Word command, it is not a macro. You can't modify it, but you can call it.