Printing

P

Patrick C. Simonds

Is there any way to cause something to print to the default printer for the
computer from which it is printed? The code works great for printing to my
network printer but this document could be printed by anyone in the building
and they are not going to want to come down to my work area to retrieve
their printout.

Private Sub CommandButton1_Click()
If CheckBox1 = True Then
Sheets("January").PrintOut Copies:=1, ActivePrinter:= _
"Paratransit_Color_Laser on Ne01:"

End If
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing Macro 1
pdf printer on each laptop different name 5
Printing 2
Print selection using check boxes 17
Problem with printing from VB-script in Excel 2
Pop Up Message before printing 3
End without Next Error 12
Print macro using xlDialogPrinterSetup fails to use driver-specific settings 0

Top