Hey,
How can I fill in the full path of an excelsheet in its footer, using vba?
Thank you
full path in excel footer
-
-
-
Hi Fluppe
Welcome to the board.
You can right click on the Excel icon, top left next ti "File", select "View Code" and past in this:
CodePrivate Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.LeftFooter = Me.FullName
Or, you can use the code to run in another Procedure.
BTW, this is a built in feature for Ecel 2002, but not prior versions:(
-
Hi Fluppe
Welcome to the board.
You can right click on the Excel icon, top left next to File, select View Code and paste in this:
CodePrivate Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.LeftFooter = Me.FullName End Sub
Or, you can use the code to run in another Procedure.
BTW, this is a built in feature for Excel 2002, but not prior versions
Edit:WillR[Yes]
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!