Path in footer
 

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

Path in footer
 

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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"a" wrote in message news:GzyVc.29125
Would somebody please remind me how to put the path and file name in the
footer? I

Path in footer
 

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)

"a" wrote in message
hlink.net...
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