If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to print file path in footer as default option for all files?
Every time I go to print format option and make a custom footer containing
the file path. Can I make this a default option? |
#2
|
|||
|
|||
How to print file path in footer as default option for all files?
File, page setup, click the header/footer tab, click footer and the second
line tells you about the path the icon to click is the one that look like a folder. -- -John Please rate when your question is answered to help us and others know what is helpful. "Loisita" wrote: Every time I go to print format option and make a custom footer containing the file path. Can I make this a default option? |
#3
|
|||
|
|||
How to print file path in footer as default option for all files?
i think i read that wrong, record a macro that does it and store it in your
personal workbook. This is what i got and it worked for me Sub Macro1() ' ' Macro1 Macro ' Macro recorded 9/19/2008 by john.bundy ' ' With ActiveSheet.PageSetup .PrintTitleRows = "" .PrintTitleColumns = "" End With ActiveSheet.PageSetup.PrintArea = "" With ActiveSheet.PageSetup .LeftHeader = "" .CenterHeader = "" .RightHeader = "" .LeftFooter = "&Z&F" .CenterFooter = "" .RightFooter = "" .LeftMargin = Application.InchesToPoints(0.75) .RightMargin = Application.InchesToPoints(0.75) .TopMargin = Application.InchesToPoints(1) .BottomMargin = Application.InchesToPoints(1) .HeaderMargin = Application.InchesToPoints(0.5) .FooterMargin = Application.InchesToPoints(0.5) .PrintHeadings = False .PrintGridlines = False .PrintComments = xlPrintNoComments .PrintQuality = 600 .CenterHorizontally = False .CenterVertically = False .Orientation = xlPortrait .Draft = False .PaperSize = xlPaperLetter .FirstPageNumber = xlAutomatic .Order = xlDownThenOver .BlackAndWhite = False .Zoom = 100 .PrintErrors = xlPrintErrorsDisplayed End With End Sub -- -John Please rate when your question is answered to help us and others know what is helpful. "Loisita" wrote: Every time I go to print format option and make a custom footer containing the file path. Can I make this a default option? |
Thread Tools | |
Display Modes | |
|
|