I feel way out of my depth here but you only get experience by having experience. This thread may also belong on the Excel board but I've started it here as I suspect the principles apply to the Ribbon in any Office application.
I understand how to layout buttons in the group but as yet I've not been able to assign a macro to a button. I know that I need to use 'onAction=' to do this but how? Simply saying onAction="nameOfMySub", as in the code below, isn't enough as that gives an error when I click the button that the rest of the code sets up, error is 'Wrong number of arguments or invalid property assignment'.
Beware of what you wish for. I was doing not to bad with my customisations until about 14;30 when Something Bad happened and the Ribbon editor corrupted my file.
Oh well that's what back-ups are for. Of course the back-up was from last night so it had none of the tweaks in it but it didn't take me long to put them back.
Once again The Lounge Magic (patent pending) kicks in and my Googling has found what I couldn't find before I posed the question here. The fix is to add an 'Optional ByVal' to the declaration, thus:
HansV wrote:..is the name of the macro that doesn't work the same as...
Good guess, I found a legacy copy of the problem macro hiding in Normal.dotm as soon as I posted, hence I pulled the plug on the post.
When I get to the end of this 'project' I'll see if I can summarise what I've learnt in a new thread. It might be useful to someone else who is starting out on this sort of thing.