Full path name in footer

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I'm using 2000 which doesn't seem to have the option of
putting the full path name in the footer. Someone gave me
the code

Sub PathInFooter()
ActiveSheet.PageSetup.RightFooter = ActiveWorkbook.FullName
End Sub

which gives me the full path name but doesn't give me the
sheet name. Should FullName give me the sheet name also or
do I need to add something. The name is really long.
Thanks. Michael
 
Substitute:
ActiveSheet.PageSetup.RightFooter = ActiveWorkbook.FullName & _
" " & ActiveSheet.Name
 

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

Print preview error from BeforePrint macro 1
Range name & Full Path in Footer 6
footer for chart sheets 4
How to display full file path name in Excel 2007 2
full path of excel file 2
Path in footer using UNC 2
full UNC path in footer 1
PowerPoint Macro for Powerpoint 2010 - Add path and file name 0

Back
Top