View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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.