Insert picture into Sheet Header

[Werewindle]

Hello,

What I would like to do is insert a picture ("mypicture") from a sheet (not a file) into another sheet header using vba.

I have an image in sheet "Data" called "myLogo".

I want to create a new sheet and generate a header. My header would have some random information in the left and center. The right header I want this image "myLogo".

Now I can do this by grabbing the image from a file on my pc, but I want this to work on other computers without them having to save the image to their pc (or exporting and importing the image.)

Any help would be greatly appreciated!

Thank you,

John

[Werewindle]

Any Ideas?

[AmirSoft]

If you insert the image file from your pc then it will not demand for a file in new pc.
Excel file completely load the picture and do not ask for destination file.