Sorry if this question has been asked before.
am using excel97.
I have dozens of worksheets all different,
I want to be able to print all these duplex
The sheets have all previously been set up as 1 page containing only the ranges required.
Odd pages should change but even pages should remain the same on all.(perhaps some reference to a single sheet through coding) but i wouldn't know how to do this tho.
is there any simples to do this?
Thanks in advance
_
am using excel97.
I have dozens of worksheets all different,
I want to be able to print all these duplex
The sheets have all previously been set up as 1 page containing only the ranges required.
Odd pages should change but even pages should remain the same on all.(perhaps some reference to a single sheet through coding) but i wouldn't know how to do this tho.
is there any simples to do this?
Thanks in advance
_
well i guess i don't have much patience and took the easy way out and used asap utilities and some creative page breaking. I made the first worksheet 2 pages, grouped all the worksheets , re-created the back sheet in page 2 of the first worksheet and copied all the page settings to all sheets. obviously i'll not be changing pg2 again and the size of my file is now giant, as all sheets now have an extra page. if anyone does have a simpler answer please post.
