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