morning,
i'm using Office 2007 on Vista, and i have the following event recorded in
"thisworkbook"

Private Sub Workbook_BeforePrint(Cancel As Boolean)
If ActiveSheet.Name = "Purchase Order (Inventory)" Then
Cancel = True
Application.EnableEvents = False
With ActiveSheet
.PrintOut
Call POInv
End With
Application.EnableEvents = True
End If
End Sub


it works, but the problem is it sends the print job to the last used printer
or the default printer. i want to beable to select the printer before it
prints - maybe another macro gets called or something. any suggestions on
getting the macro to select a printer.

thank you,

jat