Adding picture to page setup
Hi,
Thanks for your help. I too found the references, and they are a work
around. Basically it is using the ability to reproduce the first defined
rows on each sheet. It is a form of header and will do the job. It does
appear that the ability to ad a picture into the header itself is only
available in versions later than 2000.
Regards
David
"DavidC" wrote:
Hi,
I want to add a picture to the left hand header in Page setup. So far I
have tried the code that adds a picture to a worksheet but that does not seem
to work.
.LeftHeader = .Shapes.AddPicture("C:\Documents and Settings\My
Documents\Logo.jpeg", False, True, 10, 10, 70, 70)
I note that there does not seem to be a method of manually adding a picture
to the header so my guess is that it is just not possible, but would like
confirmation either that my guess it correct or that there is a way to add a
picture using VBZ.
Regards
DavidC
|