Image on heder at VBA

  • Thread starter Thread starter bilro
  • Start date Start date
B

bilro

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
 
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]
 
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???
 
Back
Top