ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Code for Page Footer Font Size (https://www.excelbanter.com/excel-programming/271420-code-page-footer-font-size.html)

John Michl[_2_]

Code for Page Footer Font Size
 
How can I change the font size in a page footer? I recorded a macro and
changed the footer and the font size but I saw nothing in the resulting code
that seemed to refer to the font?

Thanks

- John Michl



John Michl[_2_]

Code for Page Footer Font Size
 
I took a look at the recorded code again and do see the font size changes
buried in the string. To bad I didn't change the font. That would have
made it more obvious. Thanks, again. - John


"Tom Ogilvy" wrote in message
...
.LeftHeader = "abc&""Century,Italic""&14def&""Arial,Regular""&10 gh"

&14 changes it to 14 and &10 changes it back to 10.

Be careful if you have numbers in you test string. For example say you

want
to make the number 5 size 14 in the string

abc5defgh
.LeftHeader = "abc&145def&10gh"

Would make def size 145 and not show a 5.

Regards,
Tom Ogilvy


"John Michl" wrote in message
...
How can I change the font size in a page footer? I recorded a macro and
changed the footer and the font size but I saw nothing in the resulting

code
that seemed to refer to the font?

Thanks

- John Michl








All times are GMT +1. The time now is 05:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com