Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Path in Footer
Hello,
The folowing code will give you full path with font size 8 change &8 to deisired number to get another font size. With ActiveSheet.PageSetup .LeftFooter = "&8&Z&F" End With Abdul Salam -----Original Message----- I use the following code to enter the network path into the footer of my worksheet Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.LeftFooter = ActiveWorkbook.FullName End Sub How can I change the code so it does not use the default font size? The default is currently 10 and I want the path to be 8 Thank you . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
full UNC path in footer | Excel Discussion (Misc queries) | |||
Path in page footer | Excel Discussion (Misc queries) | |||
Path and File Name to Footer | Excel Discussion (Misc queries) | |||
Entering Path Name in Footer | Excel Worksheet Functions | |||
Auto Path in Footer | Excel Programming |