#1
|
|||
|
|||
How to set the footer size using VBA
Hello,
I am working on a macro that adds the footer to my Excel spreadsheet. I have the letterhead in Word and the footer is in Arial Black, bold, size 10, in a particular shade of green. How should I edit the following code, so that the footer is inputed in font 10? At the moment, the footer is inserted as Arial 11 (I guess it's Excel default font size). Quote:
|
#2
|
|||
|
|||
Solution
I figured this out alone.
Here's the solution to set the font size to 10 (change that number to get the font size you want): Code:
.CenterFooter = _ "&""Arial Black,Normale""&10&K339966MY COMPANY Ltd" & Chr(10) & "VAT registration No. GB 111 1111 11" & Chr(10) & "Registered in England and Wales No. 1111111" |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Footer, text size .doc vs .docx problem | KenZu | Word | 4 | 06-12-2013 10:38 AM |
Footer - more then one footer (auto fill text in slides) | noodle | PowerPoint | 0 | 03-31-2013 04:50 AM |
how change size font to inches size | kkepo | Word | 4 | 08-28-2012 08:53 PM |
Cursor size varies with font size | r_lewis@fuse.net | Word | 0 | 07-20-2011 06:11 PM |
Changing size of footer | izzyf | Word | 2 | 03-23-2009 12:19 PM |