+ Reply to Thread
Results 1 to 8 of 8

Printing two sheets on duplex printer

  1. #1
    Registered User
    Join Date
    09-23-2003
    Location
    California
    Posts
    38

    Printing two sheets on duplex printer

    Is if possible to set up two different sheets in the same workbook to print as front and back pages on a duplex printer?
    Last edited by hodkd; 04-09-2009 at 03:46 PM.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Printing two sheets on duplex printer

    yes, select both sheets , then print
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    09-23-2003
    Location
    California
    Posts
    38

    Re: Printing two sheets on duplex printer

    I tried that but it printed them on seperate papers just as if I printed each one seperatly.

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Printing two sheets on duplex printer

    Wouldn't you have to go into the Printer properties and change somewhere to print 2-sided... (each printer has it's own naming convention or tab the option is in... so you will have to find it)...
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  5. #5
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Printing two sheets on duplex printer

    if you select both sheets
    then [group] should appear after workbook name then go to print preview you will see them as page 1 and 2.(as long as you have only set the print area on each sheet to one page)
    make sure your printer is set to print both sides then it will do just that

  6. #6
    Registered User
    Join Date
    09-23-2003
    Location
    California
    Posts
    38

    Re: Printing two sheets on duplex printer

    I did that, picked both sheets and it said group after the name, and then when I tell it to print and set the printer to duples it prints each sheet on seperate pieces of paper.

  7. #7
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Printing two sheets on duplex printer

    sorry mate but it works fine on mine,home and work

  8. #8
    Registered User
    Join Date
    09-23-2003
    Location
    California
    Posts
    38

    Re: Printing two sheets on duplex printer

    Finnaly got the printer to print on both sides by choosing the second sheet first and then the first sheet and then telling the printer to print duplex.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1