Thread: How to set the footer size using VBA
View Single Post
 
Old 08-17-2013, 10:39 AM
Isadora Isadora is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Mar 2012
Location: Milan, Italy
Posts: 18
Isadora is on a distinguished road
Default 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:
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = ""
.CenterFooter = _
"&""Arial Black,Normale""&K339966MY COMPANY Ltd" & Chr(10) & "VAT registration No. GB 111 1111 11" & Chr(10) & "Registered in England and Wales No. 1111111"
.RightFooter = ""
Reply With Quote