currently I have this code. What keeps happening is that whenever
a user goes to a computer where their is no default printer, the print goes
automatically to Save As dialog box.

Is there a way to make it so that the Save As diablog box doesn't pop up.
The Print Dialog box pops up instead so that users can choose which printer
to print from.

Can someone add those VBA for me??


If IsNumeric(Range("F65")) = True And Range("F65") 0 And _
Range("G59") = "SAN BRUNO CABLE TV" And _
Range("F64") < "SELECT USER" And _
WorksheetFunction.CountA(Range("C61"), _
Range("C62"), Range("F61"), Range("F62"), _
Range("I61"), Range("I62")) = 1 Then

Range("A18:I69").PrintOut Copies:=1

End if