Inserting picture in footer with macro
 

I want to create a footer with a macro. I want that
footer to contain a picture. The only way I have figured
out how to do that is by writing a pathname to the
picture in the macro. However...I want the picture to be
saved and therefore carried with the file. Using a
pathname, the picture will only print if the macro is run
on my machine.

ANy ideas?

Inserting picture in footer with macro
 

Thanks anyway.

-----Original Message-----
Martin,
Excel 2000 you can't have a picture in the footer. Newer
versions, who
knows.
You can fake it with a suitably positioned picture on
the worksheet, then
repeated rows.

NickHK


"Martin" wrote in
message
...
I want to create a footer with a macro. I want that
footer to contain a picture. The only way I have
figured
out how to do that is by writing a pathname to the
picture in the macro. However...I want the picture to
be
saved and therefore carried with the file. Using a
pathname, the picture will only print if the macro is
run
on my machine.

ANy ideas?


.

Inserting picture in footer with macro
 

Martin,
Excel 2000 you can't have a picture in the footer. Newer versions, who
knows.
You can fake it with a suitably positioned picture on the worksheet, then
repeated rows.

NickHK


"Martin" wrote in message
...
I want to create a footer with a macro. I want that
footer to contain a picture. The only way I have figured
out how to do that is by writing a pathname to the
picture in the macro. However...I want the picture to be
saved and therefore carried with the file. Using a
pathname, the picture will only print if the macro is run
on my machine.

ANy ideas?