G
Guest
I created a macro to print certain documents in Excel
after it prints I want the printer to default back to the
original printer not the one I created. I used the below
formula for the macro, but it's not defaulting back, can
you help me with this?
Application.ActivePrinter = "\\albprn01\finlj02 on Ne03:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1,
ActivePrinter:= _
"\\albprn02\finlj02 on Ne03:", Collate:=True
End Sub
after it prints I want the printer to default back to the
original printer not the one I created. I used the below
formula for the macro, but it's not defaulting back, can
you help me with this?
Application.ActivePrinter = "\\albprn01\finlj02 on Ne03:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1,
ActivePrinter:= _
"\\albprn02\finlj02 on Ne03:", Collate:=True
End Sub