#1   Report Post  
Frank R
 
Posts: n/a
Default 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   Report Post  
Ron de Bruin
 
Posts: n/a
Default

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   Report Post  
Bob Phillips
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel printer Roger Excel Discussion (Misc queries) 1 April 30th 05 04:17 PM
Fit Selection Setting Doesn't Hold Brett Excel Discussion (Misc queries) 1 April 20th 05 10:22 PM
No printer select in excel jj Excel Discussion (Misc queries) 1 March 25th 05 12:34 PM
Why won't Excel start up without asking for a printer? Dave Excel Discussion (Misc queries) 1 March 16th 05 05:17 AM
limit cell list selection based on the selection of another list lorraine Excel Worksheet Functions 2 December 14th 04 09:17 PM


All times are GMT +1. The time now is 12:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"