Excel - setting the Left or Right HeaderPicture

Asked By NickHK on 22-Mar-07 10:00 PM
Marks,
According to the VBA Help:
With ActiveSheet.PageSetup.LeftHeaderPicture
.FileName = "C:\Sample.jpg"
......... etc

' Enable the image to show up in the left header.
ActiveSheet.PageSetup.LeftHeader = "&G"

End Sub
Note   It is required that "&G" is a part of the LeftHeader property string
in order for the image to show up in the left header.


NickHK

I
(Excel.PageSetup)xlSheet.PageSetup;