In Excel 2000, I am using following code to print the full path name current file in my Footer.

Private Sub Workbook_Open()
    ActiveSheet.PageSetup.LeftFooter = "&8" & ActiveWorkbook.FullName
End Sub
The macro works fine. I edit and/or create about 20 different spreadsheets each day and I want to use the same macro everytime without having to create the same code for every workbook.

Is there a way to do this so I can use over and over? Also, how can I add a button to my toolbar to use this code again and again with one click (if it is possible)?

Thanks in advance for any comments/help.