Microsoft Office Forums - View Single Post - How to set the footer size using VBA

Thread: How to set the footer size using VBA

View Single Post

Old

08-20-2013, 05:50 AM

Isadora

Isadora is offline

Isadora uses Windows 7 32bit

Windows 7 32bit Isadora uses Office 2010 32bit

Isadora uses Office 2010 32bit

Office 2010 32bit

Novice

The original poster

Join Date: Mar 2012

Location: Milan, Italy

Posts: 18

Isadora is on a distinguished road

Default

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"

Reply With Quote