Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
in excel; page size is adjusing, not print size on page. | Excel Discussion (Misc queries) | |||
Excel footer default font size | Excel Worksheet Functions | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
Footer font resize when "fit to page" | Excel Discussion (Misc queries) | |||
Change all text one font size up with various font sizes used. | New Users to Excel |