footer

  • Thread starter Thread starter Ismael
  • Start date Start date
I

Ismael

I want to know how to put the file path on the footer.
I've been looking for it and I just can't seem to find it.
can someone help?
 
one way:

Put this in the ThisWorkbook code module (right-click on the
workbook title bar, choose View Code, paste the following in the
window that opens, then click the XL icon on the toolbar to return
to XL):

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim wkSht As Worksheet

For Each wkSht In ActiveWindow.SelectedSheets
wkSht.PageSetup.LeftFooter = ActiveWorkbook.FullName
Next wkSht
End Sub

You can substitute CenterFooter or RightFooter for LeftFooter.

Note that XL02/3 have this option already.
 
Back
Top