Hi
I wish to add a logo/picture into the footer on all of my tabs.
In the older versions there was a tab for this but in this version there is not.
Hope someone can help me.
Hi
I wish to add a logo/picture into the footer on all of my tabs.
In the older versions there was a tab for this but in this version there is not.
Hope someone can help me.
Microsoft left this particular feature OUT of Excel 2016.
Oops.
This code works in previous versions of Excel to add a logo into the footer of all tabs. Fingers crossed this works for you.
[code]Sub AddLogo()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.PageSetup.CenterFooterPicture.Filename = "C:\MyCompanyLogo.gif"
Next ws
End Sub
[code]
It may not.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks