VBA Code to add Logo to Header

[daopsmatt]

Hello,

We have 6 different spreadsheets all because we need a logo to print on one of the worksheets when it is printed out. I am sure there is a way to do this through VBA coding.

Goal: When worksheet is printed, based on data in a cell use the right logo in header.

I am a novice with VBA and don't work very much with it, but finding it more and more useful. Was using it more a while ago, then company started using SharePoint Online and VBA doesn't work very well with that.

Any help would be great.

Thank you for your help,

Matt

 

[Millermiller]

Matt, I never do it before, but I think it possible to make it as you word. So I do some search on Mrexcel and find this link may help: add logo

It was also telling about how to add logo using VBA.