CODEWITHSUNDEEP
vbaexcel
Ayman
Ayman

Reputation: 1463

How to link an image to the header

I have an Excel sheet where I am using an image in the header. From this question I already know how to add or link images as Shapes in an Excel sheet.

Now I need to do something similar to the header, where I can link an Image to the header instead of saving the image in the Workbook (because I have a lot of images which makes the file size huge).

Upvotes: 1

Views: 681

Answers (1)

Mr. Mascaro
Mr. Mascaro

Reputation: 2733

Code:

Sheet.PageSetup.LeftHeaderPicture.Filename

You need to set the Filename property of the _____HeaderPicture property to the path of the picture you want to use.

Upvotes: 2

Related Questions