Oh, now I understand....
Mala Prabhu is most likely correct, but this is a challenge that is easier said than done. I am captivated by such challenges.
Much easier to say, in truth.
I must complement you on the effort to make things easy for the 'customers' of your work. I am impressed. Good Job.
Here is an idea. It's a style of "Work Hard", not "Work Smart". Sometimes, working hard is smarter than working smart.
Here it is.
Print some blank landscapes; just the footer/header goodies will be printed. You may need to fool Excel into printing it by adding something to the page. Maybe a period, printed faintly.
When you print your Portrait pages, use the pre-printed stock.
You know how often you need to do this; perhaps a macro to print the 'regular' pages, then prompt user to load the pre-printed paper stock is in order.
My solution isn't exactly 'smart' but I would claim it's 'elegant'
This message was edited by stevebausch on 2002-10-10 03:31