how to add my company logo as footer on every sheet vba.

[VISHAL120]

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]

Just put it in the Footer, View>Header and Footer...

[VISHAL120]

Hi Bob,

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

[Paul_Hossler]

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]

Hi ,

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

[Aussiebear]

Only if you are prepared to change the footer style to text.....

[JP2112]

Rewrite this code to loop through each sheet in the workbook (after the first).

[VBA]ActiveSheet.PageSetup.CenterFooterPicture.fileName = _
"C:\MyCompanyLogo.gif"[/VBA]