Multiple headers

  • Thread starter Thread starter Gus Knoops
  • Start date Start date
G

Gus Knoops

Hello,

I've a worksheet that contains Printing titles and a custom footer. The
print title contains an image (jpg).
Now I require that the image changes half way through the pages. I cannot
find a way to do it (similar to the sections in Word that allows you to do
that).

Does anybody have some advice? Do you need VBA to do this?

thanks,
Gus
 
You'll need a macro.

Record a macro when you change the picture, print the first set, change the
picture and print the next set.

And you'll be pretty much done.
 
Two separate print jobs would be the way to go.

You could do it with VBA but would still be two print jobs.


Gord Dibben MS Excel MVP

On Mon, 11 Jan 2010 07:14:01 -0800, Gus Knoops <Gus
 
Back
Top