lior03
08-16-2007, 08:59 AM
hello
i have a computer at work which is connected to two printers.
i would like to be able to select my own printer only if the number of printer is greater then one.
If MsgBox(Application.activeprinter & "change?", vbInformation + vbOKCancel, "activerinter is:") = vbOK Then
Application.Dialogs(xlDialogPrinterSetup).Show
End If
i have a computer at work which is connected to two printers.
i would like to be able to select my own printer only if the number of printer is greater then one.
If MsgBox(Application.activeprinter & "change?", vbInformation + vbOKCancel, "activerinter is:") = vbOK Then
Application.Dialogs(xlDialogPrinterSetup).Show
End If