Thread
:
is it possible to print multiple pages with different numbers
View Single Post
#
6
Posted to microsoft.public.excel.misc
Ron de Bruin
external usenet poster
Posts: 11,123
is it possible to print multiple pages with different numbers
Hi Anne
I never have a duplex printer so I not know
Maybe others can test it for you.
Sorry
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Anne Moore" <Anne
wrote in message ...
This macro was just what I was looking for. We are trying to print a log
book, which consists of just one page and wanted it numbered page1, page2,
page3, etc. I used the macro option to print the number in the footer.
However, our user wants to use our duplex print, so that page 2 will print on
the back of page 1, page 4 will print on the backup of page 3 etc. We have
duplex enabled in our printer driver and is set at default in our printer
properties. When I run the macro, the printer does feed it through again, to
print on the other side, but it comes out blank. So, we are getting page 1,
then a new page for page 2, new page for page 3 etc.
This seems so close to what we are looking for. Ist there a statement that
can be added to the macro to print on the duplexed side ?
Thanks, Anne
"Ron de Bruin" wrote:
If I understand you correct ?
See
http://www.rondebruin.nl/print.htm#same
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"des-sa" wrote in message ...
please help.
how do i print multiple copies of the same worksheet, but numbered
consecutively.
Reply With Quote
Ron de Bruin
View Public Profile
Find all posts by Ron de Bruin