Printing odd and even page footers
 

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

Printing odd and even page footers
 

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

Urban Landreman

"ULandreman" wrote:

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

Printing odd and even page footers
 

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


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


"ULandreman" wrote:

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

Urban Landreman

"ULandreman" wrote:

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

Printing odd and even page footers
 

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" wrote:

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


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


"ULandreman" wrote:

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

Urban Landreman

"ULandreman" wrote:

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

Printing odd and even page footers
 

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

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


"ULandreman" wrote:

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" wrote:

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


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


"ULandreman" wrote:

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

Urban Landreman

"ULandreman" wrote:

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