D David Rosen Jul 24, 2003 #1 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?
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 Jul 24, 2003 #2 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
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 Jul 24, 2003 #3 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
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