Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    271

    Unanswered: Pause to print back page

    I am looking for a macro that will print... then put up a message and pause... so we can turn the paper over (to print the back) then I hit OK and it prints!!

    Any help would be great!!

    Michael
    Gotta to do some code

  2. #2
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    How about something like this:

    Code:
    Sub PrintMe()
        Range("A1:C6").PrintOut
        MsgBox "Please click OK AFTER you've turned the paper over", _
            vbOKOnly + vbInformation, "Print Back Page"
        Range("A10:C20").PrintOut
    End Sub
    HTH,

    Smitty

  3. #3
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    271
    This is great if the info is on the same page. How do I specify, if the info is on a second tab?


    Thank You,
    Michael
    Gotta to do some code

  4. #4
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    Change: Range("A10:C20").PrintOut to Sheets("Sheet Name").Range("A10:C20").PrintOut

    Smitty

  5. #5
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    271
    Thank You

    Michael
    Gotta to do some code

Posting Permissions

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