Macros - Icon on a Ribbon

[AlexiAlex]

Using VB I recorded a Macro and I also created a customized Icon for this particular Macro on the home Tab.

FYII: I protected the whole workbook with the macro to serve as template whoever needs to use the worksheet first need to resave it with different name.

How can make the Icon of this Macro still works when I resave the worksheet in different name?

[NeedForExcel]

If it is an Icon at the Top of the Ribbon (Which Is actually called the Quick Access Toolbar), I don't think it moves with the Workbook.. Its a part of the Application..

[romperstomper]

You'll have to create the button using XML in the CustomUI.xml part. Any button you add to the ribbon using the UI is tied to a specific file path.