Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Printer Selection
I would like to add to the toolbar a "print" icon for a specific printer
(actually my paperless office printer). I know I can change the default printer and also select a printer, then the default printer is the last used printer. But I would like to create a "static" print icon that does not change when I do actually change the printer selection for other ACTUAL printers. Is this possible???? |
#2
|
|||
|
|||
Hi Frank
You can assign a macro like this to the button It save the active printer first and then change it to the printer you want. Print the activesheet and restore the active printer Dim DPrinter As String DPrinter = Application.ActivePrinter Application.ActivePrinter = "Microsoft Office Document Image Writer on Ne01:" ActiveSheet.PrintOut Application.ActivePrinter = DPrinter -- Regards Ron de Bruin http://www.rondebruin.nl "Frank R" <Frank wrote in message ... I would like to add to the toolbar a "print" icon for a specific printer (actually my paperless office printer). I know I can change the default printer and also select a printer, then the default printer is the last used printer. But I would like to create a "static" print icon that does not change when I do actually change the printer selection for other ACTUAL printers. Is this possible???? |
#3
|
|||
|
|||
Frank,
Haven't tried it, but this might work Sub printToCanon() Dim currPrinter With Application currPrinter = .ActivePrinter .ActivePrinter = "Canon Bubble-Jet BJC-4300 on LPT1:" ActiveWindow.SelectedSheets.PrierntOut .ActivePrinter = currPrinter End With End Sub -- HTH RP (remove nothere from the email address if mailing direct) "Frank R" <Frank wrote in message ... I would like to add to the toolbar a "print" icon for a specific printer (actually my paperless office printer). I know I can change the default printer and also select a printer, then the default printer is the last used printer. But I would like to create a "static" print icon that does not change when I do actually change the printer selection for other ACTUAL printers. Is this possible???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel printer | Excel Discussion (Misc queries) | |||
Fit Selection Setting Doesn't Hold | Excel Discussion (Misc queries) | |||
No printer select in excel | Excel Discussion (Misc queries) | |||
Why won't Excel start up without asking for a printer? | Excel Discussion (Misc queries) | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions |