Created add-in - how to get it on ribbon with button

Hi all,

I've Googled this but can't find a set of clear instructions. I have created an Excel add in which once installed will allow people in my office to run a relevant macro.

I have stored the macro in ThisWorkbook, saved it as an Add-in file (in the default directory where the standard ones are) and loaded it into Excel. When I open a blank workbook I can see that the macro is loaded in Project Explorer. All great so far.

However I'd like the macro to appear on the ribbon as a new tab (with a custom button) so that it is easy for the user to use - how do I do this?

Any help would be brilliant.

Thanks Izandol. I found the one where there is a green arrow on the QAT but I really am looking for something that will add itself to the ribbon.

Hmm. I can't seem to get it to work.

Thanks for the link.

Thanks Izandol! Will any changes I make travel with the workbook? I.e. will other users see them (I want them to)?

Brill. Thanks again. Appreciate your time. Rep left.