Footer Info

A

André M.

Hi all,

I need to have the footer of a spreadsheet i just created
display the path i.e. c:\documents\documents here\this.doc

I know i can do it in word but can't figure out how to
have it done in this spreadsheet.

Thanks

A.
 
B

Bob Phillips

Andre,

You need VBA. In the ThisWorkbook code module, add this code

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

Gord Dibben

Unless you have Excel 2002, which has the fullpath feature in Custom.

Note: the workbook must be saved at least once in order for it to have a path.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Top