Path in footer

[a]

Hello,

Would somebody please remind me how to put the path and file name in the
footer? I haven't had to do this in awhile, and I'm being too lazy too
look it up. I guess I shouldn't admit to that - but if any of you are
dealing with Sarbanes-Oxley - you know why.

Thanks in advance for any help that you can give.

Regards,
anita

 

[David McRitchie]

Hi Anita,
see my page
http://www.mvps.org/dmcritchie/excel/pathname.htm

and if you have Excel 2002 you don't need a macro.
http://www.mvps.org/dmcritchie/excel/pathname.htm#sp

 

[Bob Phillips]

Hi Anita

You can use VBA to set the BeforePrint to print the same footer

Private Sub Workbook_BeforePrint(Cancel As Boolean)
With ActiveSheet
.PageSetup.LeftFooter = Activeworkbook.Fullname
End With
End Sub

Put this in ThisWorkbook code module

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)