View Single Post
  #2   Report Post  
Nick Hodge
 
Posts: n/a
Default

Your only way is to upgrade to Excel XP (2002) or above.

You can also put some code in your personal.xls and run it. The code below
puts the full path and fie name into the right footer of the activesheet
(Must be saved for the first time our their is no path!)

Sub FileNameInFooter()
Dim FName As String
FName = ActiveWorkbook.FullName
ActiveSheet.PageSetup.RightFooter = FName
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"be" wrote in message
...
I would like to print the file path and default location in a footer on my
file but the footer does not have the icon for this command how do i get
this
icon ? please