Is there a way to add the path to a file name in an Excel footer? We are using Office 2000. Thanks.
S Stacy O Feb 16, 2004 #1 Is there a way to add the path to a file name in an Excel footer? We are using Office 2000. Thanks.
R Ron de Bruin Feb 16, 2004 #2 Hi Stacy http://www.j-walk.com/ss/excel/tips/tip22.htm See John's tip on this for Excel 97-2000 Excel 2002/2003 have this option build in
Hi Stacy http://www.j-walk.com/ss/excel/tips/tip22.htm See John's tip on this for Excel 97-2000 Excel 2002/2003 have this option build in
B Bob Phillips Feb 16, 2004 #3 Stacy, You can use VBA to set the BeforePrint to print the same footer Private Sub Workbook_BeforePrint(Cancel As Boolean) With ActiveSheet .PageSetup.LeftFooter = Activeworkbook.Fullname End With End Sub Put this in ThisWorkbook code module -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
Stacy, You can use VBA to set the BeforePrint to print the same footer Private Sub Workbook_BeforePrint(Cancel As Boolean) With ActiveSheet .PageSetup.LeftFooter = Activeworkbook.Fullname End With End Sub Put this in ThisWorkbook code module -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
