Pause to print back page

surfacesys · #1 (**permalink**) 12-14-04, 18:00

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

Smitty · #2 (**permalink**) 12-15-04, 18:24

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