How do I take a macro in a workbook and make it apply for all workbooks

[dano1352]

I have a macro I created in a an Excel workbook but it only works if that file is open or it opens that workbook automatically. How do I take this macro and put it on the ribbon and make it work in every file I open in Excel? Here is the code:


Sub Footer()
ActiveSheet.PageSetup.CenterFooter = "ISO 9001 CERTIFIED"
End Sub

 

[dmt32]

Hi,
welcome to forum

have a read here:https://support.office.com/en-us/ar...workbook-aa439b90-f836-4381-97f0-6e4c3f5ee566

and see if this solution meets your requirement

Dave

 

[dano1352]

That was a big help. Thank you Dave!

 

[dmt32]

That was a big help. Thank you Dave!

Most welcome - thanks for feedback

Dave