Printing odd and even page footers

[ULandreman]

Having different footers in Word for odd and even pages is trivial.
How can one do it in Excel 2003?
I've seen how to set the footer programmatically in VBA.
But, the examples I've seen set the footer once for the entire document.

Any suggestions or places I can find the necessary VBA code?

Thanks.

Urban Landreman

 

[ULandreman]

This accidentally got posted twice.
Sorry about that.
As Emily Litella would say, "Never mind".

Urban Landreman

 

[ryguy7272]

One method:
http://www.rondebruin.nl/print.htm#odd


HTH,
Ryan---

 

[ULandreman]

Hello,

That did help.
My spreadsheet is about 50 pages long, so it's a bit of manual work at the
end to get it back into one document, but it definitely did the functionality
I wanted.

Thanks!

Urban

 

[ryguy7272]

If this information was helpful, please indicate this by clicking ''Yes''.