How to set the footer size using VBA

		Microsoft Office Forums > Microsoft Excel > Excel
How to set the footer size using VBA

FAQ

Thread Tools

Display Modes

08-20-2013, 05:50 AM

Isadora

Windows 7 32bit How to set the footer size using VBA

Office 2010 32bit

Novice

Join Date: Mar 2012

Location: Milan, Italy

Posts: 18

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"

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:29 PM.