Results 1 to 3 of 3

Thread: Printing Help

  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Toronto, canada
    Posts
    23
    Thanks
    2
    Thanked 0 Times in 0 Posts
    I have a two page report for which I created a print macro. I would like to stop the print job after page one so that I can turn over the page just printed (saving paper) and press a button to continue after the page is inserted in the printer.

    Any help will be appreciated. Thanks

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    You should be able to edit your macro so it uses the following commands

    Code:
    ActiveSheet.PrintOut From:=1, To:=1, Copies:=1
    MsgBox "Change the Paper Now",vbExclamation
    ActiveSheet.PrintOut From:=2, To:=2, Copies:=1
    Andrew

  3. #3
    New Lounger
    Join Date
    Dec 2009
    Location
    Toronto, canada
    Posts
    23
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Thank You, Worked like a charm.

Posting Permissions

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