Rebuilding Header in VBA with an Embedded Image

I have a Header with an Embedded Image in it. I use the image like a letterhead or watermark when the file is printed. It doesn't seem to be possible to protect the header from being changed by the user via worksheet protections and the workaround seems to be to rebuild the header with VBA, like so:

Please Login or Register  to view this content.

(Thanks to Ekim: http://www.mrexcel.com/forum/excel-q...es-header.html)

I wonder if it is possible to change .Filename = "C:\Temp\logo.jpg" to point to an embedded image hidden on a different, protected sheet, or something similar? Users won't have the image as a local file on their computer so I'm wondering if I can pack it up with the excel document somehow.

Thank you for your help!

That sounds like it would work. It's getting late tonight but I'll give it a try tomorrow and let you know how it goes.

Thank you for the advice

Originally Posted by Izandol

You may simply store inside an ActiveX Image control. Then you may use:

Please Login or Register  to view this content.

I gave the ActiveX control a shot. It seems to take my jpeg file and convert it into a bmp. This is causing the filesize of the workbook to balloon and performance takes a big hit. Is it possible to keep the file as a jpeg?

The jpeg is 376 kb but it contains a lot of white space. When uncompressed as a bmp my workbook increases in filesize by about 4 mb.

Using the chart has a few drawbacks. The picture loses some quality and I have to be careful about moving the focus of the workbook to the chart when saving but it does work well enough.

Thanks again for your help

The image is large because it covers the whole page. It's the background image we use for letterhead and my charts are printed on top of it. That's also why it has a lot of white space and why it becomes enormous as a BMP

I downloaded Stephen's code but to be honest it seems a bit over my head . I'm not really sure how it would help me either. If ActiveSheet.PageSetup.LeftHeaderPicture.Filename only accepts a string with a path to a file on the hard drive, how will moving picture object through the clipboard help?

I gave Stephen's code a try with your call. It does take an embedded image object and save it to disk but only as bmp or metafile (which I think is just a wrapper for bmp?). This again creates a giant file. The large bmp it creates isn't even very good looking. I was able to get better image quality by exporting the chart like I did in post #4

As a side note, I've found that when I export the chart, another interesting property is that the quality of the resulting exported image depends on what zoom setting the chart is on at the time. If the chart is zoomed far out I get a small blurry image, but if it's zoomed in I get a large clear image.

The chart method is a bit silly but I think it works for me.