Path in footer

  • Thread starter Thread starter a
  • Start date Start date
A

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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sarbanes Oxley Question - tracking changes in macros 1
Footer Program 3
How do I insert the name of a named range in a footer in Excel? 2
show file path in Print footers 3
Adding a line in footer 1
Headers and Footers by VBA? 6
Word 07 - Insert file path in footer 4
Path in Footer 3

Back
Top