View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jake Marx[_3_] Jake Marx[_3_] is offline
external usenet poster
 
Posts: 860
Default 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/