footer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Burt - 18 Nov 2003 16:48 GMT

I would like to be able to automatically print the path of an excel document
in the footer.On an older version of excel, now using 2000 I could click on
an icon in the custom footer box and this would occur. I cannot find the
icon or can I find a way to set it up.
Thanks

Reply to this Message

Paul B - 18 Nov 2003 18:05 GMT

Burt, you can do it with a macro like this, put in this workbook code

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftFooter = ActiveWorkbook.FullName
End Sub

Signature

Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

> I would like to be able to automatically print the path of an excel document
> in the footer.On an older version of excel, now using 2000 I could click on
> an icon in the custom footer box and this would occur. I cannot find the
> icon or can I find a way to set it up.
> Thanks

Reply to this Message

Rate this thread: