Macro to add path to footer

[Terry]

After successfully creating a macro to add the workbook
path to the footer, as described in the Microsoft
Knowledge Base Article-213615, I found that I could not
alter the font of the resulting footer text. Can anyone
provide directions that will allow the ability to specify
the characteristics of the footer text? Please post both
to the newsgroup and direct reply. Thanks

 

[Bob Phillips]

Terry,

This changes the font, bold attribute and size

With ActiveSheet.PageSetup
.LeftFooter = "&""Arial,Bold""&12&A" & ActiveWorkbook.FullName
End With


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)