Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
spreadsheets to have default footer showing path | Setting up and Configuration of Excel | |||
Setiiing up file name & path as a default setting on all sheets/ta | Excel Discussion (Misc queries) | |||
Print file path | Excel Discussion (Misc queries) | |||
Path and File Name to Footer | Excel Discussion (Misc queries) | |||
print file path and location in a footer | New Users to Excel |