Image on heder at VBA
 

to text i use :
Worksheets("Example").PageSetup.LeftHeader = "&B&12My left header"

visalization:
_______________________________________________

My left Header




_______________________________________________

i would like to add an image at the begining of the left header

new visalization:
_______________________________________________

(||) My left Header




_______________________________________________

legend : (||) - image jp

--
Message posted from http://www.ExcelForum.com

Image on heder at VBA
 

Hi bilro,

You can do this with Excel 2002 or newer:

With Sheet1.PageSetup
.LeftHeaderPicture.Filename="c:\myimage.jpg"
.LeftHeader="&G Howdy folks"
End With

The &G tells Excel where to put the image.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


bilro wrote:
to text i use :
Worksheets("Example").PageSetup.LeftHeader = "&B&12My left header"

visalization:
_______________________________________________

My left Header




_______________________________________________

i would like to add an image at the begining of the left header

new visalization:
_______________________________________________

(||) My left Header




_______________________________________________

legend : (||) - image jpg


---
Message posted from http://www.ExcelForum.com/

Image on heder at VBA
 

is it possible to do:

dim i as Image

With Sheet1.PageSetup
..LeftHeaderPicture=i
..LeftHeader="&G Howdy folks"
End With

or somethig for the style???


---
Message posted from http://www.ExcelForum.com/