Insert Picture in Footer

[tkaplan]

Good afternoon,

I have a file named "SNCLogo49.png" saved in folder C:\Logos\2015.
I am trying to add to my macro that that picture is automatically inserted as the footer. I tried:


With ActiveSheet.PageSetup
.RightFooterPicture.Filename = "C:\Logos\2015\SNCLogo49.png"
' I have a bunch of other page setup things that are working after this line
End With


But for some reason it's not working.

What am I missing?

Thanks,
T

[Kenneth Hobs]

You need to enable it.

Sub ken()
With ActiveSheet.PageSetup
'http://msdn.microsoft.com/en-us/library/office/ff840868(v=office.15).aspx
.RightFooterPicture.Filename = "C:\Logos\2015\SNCLogo49.png"
' Enable the image to show up in the right footer.
.RightFooter = "&G"
End With
End Sub

[tkaplan]

Thank you so much! It worked :)