How to convert a macro to an Add-in with button on Ribbon?

[actuary0123]

I have developed a macro with help from you guys and now I am at the last step.

I want to convert it into an add-in to share with my colleagues and the add-in should be available on the Ribbon so a user can click it to run the macro.

Any guidance would be very helpful.

Thank you.

 

[Rijnsent]

Hi actuary0123,

assuming you have a working workbook with your code, you probably first need to change the ribbon; did you already visit the site of Ron de Bruin, he has a complete section on the Ribbon: Ribbon and Quick Access Toolbar pages
Then you just need to save it as an Add-in, Chip Pearson has a short howto here: Creating An XLA Add In

Hope those pointers help?

Koen

 

[actuary0123]

Hi actuary0123,

assuming you have a working workbook with your code, you probably first need to change the ribbon; did you already visit the site of Ron de Bruin, he has a complete section on the Ribbon: Ribbon and Quick Access Toolbar pages
Then you just need to save it as an Add-in, Chip Pearson has a short howto here: Creating An XLA Add In

Hope those pointers help?

Koen

Thank you for your comment. I did find enough help at Ron de Bruin's page to complete my task.