show file path in Print footers

  • Thread starter Thread starter Guest
  • Start date Start date
Or just use a macro like so..

Sub PathInFooter()
ActiveSheet.PageSetup.RightFooter = ActiveWorkbook.FullName & " " & _
ActiveSheet.Name & " " & Application.UserName & " " & Date
End Sub


Gord Dibben Excel MVP
 

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

Adding code right after the "Save As" dialog box 2
Footer Color 2
Further Challenges with Footers and automatic text wrapping 1
Pictures in Footers (again!) 4
Saving filename and file save date? 1
Need help with a Macro or VB code for Header/Footer 6
Headers and Footers by VBA? 6
Insert total of page in a worksheet in a cell 2

Back
Top