How can I have this apply automatically to all new workbooks? I
tried putting this in the Personal.xls BeforeSave event but it didn't
work on new workbooks.





For Each wksht In Excel.Sheets

wksht.PageSetup.CenterFooter = "Created by Billy Rogers &D"

Next wksht