Adding file path to worksheet footer

D

David Rosen

An icon allows for the addition of the file name to a worksheet footer. How
can the path for the file name be added to the footer?
 
G

Gord Dibben

David

If using XL2002, there are icons in Headers/Footers Custom section for Path
and Filename.

If you are not using XL2002 you have to use a macro to do this.

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

The same code could be placed into a Workbook_BeforePrint routine.

If unfamiliar with macros visit David McRitchie's website for basics.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
M

Malcolm Graham

Here is what I do:
(MS Office XP version of Excel)

FILE
PAGE SETUP
Header/Footer Panel
Footer
(use the drop-down menu, and
Filename&Path is one of the options that appears)
MG
 
Top