PDA

View Full Version : select active printer



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

mdmackillop
08-16-2007, 09:23 AM
Hi Moshe,
I've done a couple of KB items on printers in excel.

Bob Phillips
08-16-2007, 09:28 AM
Always best to let the user control it. Devolved responsibility.



application.Dialogs(xlDialogPrint).Show