How do I automatically add filepath to an Excel footer 1

[bigcat]

How do I automatically add filepath to an Excel footer

 

[LarryDeLaruelle]

Create a macro that records step by step the process you currently use to insert the footer. Be sure to save the macro in the Personal.xls.

Add the macro as a button on the tool bar.

Then all you have to do is click on the button to insert the footer information you want.

 

[BobCrawf]

You can put the MACRO in the 'This Workbook' VBE module as a Before Print Sub. It will then print the footer without having to click on a command button.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftFooter = "&F &A"
End Sub

You can change LeftFooter to RightFooter or CenterFooter