PDA

View Full Version : how to add my company logo as footer on every sheet vba.



VISHAL120
09-05-2011, 01:58 AM
Hi All,

How can i add my company Logo as footer on every page through vba.

that is on every page if data is on more than one page the logo is added for 2nd page.

actually am adding it on every sheet and i have somtimes to insert lines so that the logo is display on the footer of every page.

thanks for the help in advance.

see example attached .please preview to see the logo it has been put for every page but place on the sheet manually.

Bob Phillips
09-05-2011, 02:19 AM
Just put it in the Footer, View>Header and Footer...

VISHAL120
09-05-2011, 03:21 AM
Hi Bob,

The logo is in shapes but not written. It is not written. Written is easily place on the footer.

Paul_Hossler
09-05-2011, 06:43 AM
In pre-2007 Excel, footers did not have an easy way to put a graphic into the footer.

It's a lot easier with 2007

Paul

VISHAL120
09-05-2011, 06:56 AM
Hi ,

But in my company we all use excel 2003. is there not a way to do this in VBA please .

Aussiebear
09-05-2011, 03:20 PM
Only if you are prepared to change the footer style to text.....

JP2112
09-06-2011, 07:48 AM
Rewrite this code to loop through each sheet in the workbook (after the first).

ActiveSheet.PageSetup.CenterFooterPicture.fileName = _
"C:\MyCompanyLogo.gif"