Macro Buttons to appear for every worksheet when excel add-in is enabled

[graceface21]

Hi,

I absolutely love this site! I couldn't find a thread that answers this question:

I have a macro that currently runs VBA code once a button is selected- I have since made this into an Excel Add-In/Plugin. However, when I enable my excel-addin for a new worksheet/book, the buttons disappear. Is there a way I can generate those same buttons that were made in fixed locations to open the same in a new worksheet when the add-in is enabled?

Thanks, Grace

 

[bobsan42]

Can't you use the ribbon for that purpose?
Add CustomUI tab to the addin the it will be available when the addin is loaded.
I find this approach much more convenient once you get used to it.

 

[graceface21]

How do I add in CustomUI?

Can't you use the ribbon for that purpose?
Add CustomUI tab to the addin the it will be available when the addin is loaded.
I find this approach much more convenient once you get used to it.

 

[bobsan42]

There are plenty of tutorials all over the web.
Try this for example:
How to Customize the Excel 2016 Ribbon with XML - dummies