Alternative Printer Button
 

Hi,
In Excel, I'd like to set up an "alternative printer button". In other
words, the standard Excel print execution (File/Print or Print button icon)
would print to the PC's standard default printer. But the Excel toolbar
would now have a second print button, that would print to an alternative
printer, but leave the default printer unchanged. Thanks in advance for
whatever assistance folks can provide.

Alternative Printer Button
 

Right click in the toolbar and choose "Customize", then <Commands tab,

Click "File" in the left window and scroll down in the right window until
you come to 2 identical "Print" icons.

One will automatically print to the default printer (probably what you have
on your toolbar), and the other will give you a choice of installed
printers.

You can drag this to your toolbar and change the icon if you wish.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"JimK" wrote in message
...
Hi,
In Excel, I'd like to set up an "alternative printer button". In other
words, the standard Excel print execution (File/Print or Print button icon)
would print to the PC's standard default printer. But the Excel toolbar
would now have a second print button, that would print to an alternative
printer, but leave the default printer unchanged. Thanks in advance for
whatever assistance folks can provide.

Alternative Printer Button
 

Thank you very much. However, having done this, now when I click on the new
printer icon, it seems to change the Excel default printer to the new printer
(for both icons). Am I missing something?

"RagDyeR" wrote:

Right click in the toolbar and choose "Customize", then <Commands tab,

Click "File" in the left window and scroll down in the right window until
you come to 2 identical "Print" icons.

One will automatically print to the default printer (probably what you have
on your toolbar), and the other will give you a choice of installed
printers.

You can drag this to your toolbar and change the icon if you wish.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"JimK" wrote in message
...
Hi,
In Excel, I'd like to set up an "alternative printer button". In other
words, the standard Excel print execution (File/Print or Print button icon)
would print to the PC's standard default printer. But the Excel toolbar
would now have a second print button, that would print to an alternative
printer, but leave the default printer unchanged. Thanks in advance for
whatever assistance folks can provide.

Alternative Printer Button
 

No, you're not missing anything ... I'm just explaining it very badly.

I meant to bring to your attention the fact that there was an icon that
allowed you to choose a printer ... that's all.

I believe you'll need some code (record a macro) to assign separate icons to
specific printers.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JimK" wrote in message
...
Thank you very much. However, having done this, now when I click on the
new
printer icon, it seems to change the Excel default printer to the new
printer
(for both icons). Am I missing something?

"RagDyeR" wrote:

Right click in the toolbar and choose "Customize", then <Commands tab,

Click "File" in the left window and scroll down in the right window
until
you come to 2 identical "Print" icons.

One will automatically print to the default printer (probably what you
have
on your toolbar), and the other will give you a choice of installed
printers.

You can drag this to your toolbar and change the icon if you wish.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"JimK" wrote in message
...
Hi,
In Excel, I'd like to set up an "alternative printer button". In other
words, the standard Excel print execution (File/Print or Print button
icon)
would print to the PC's standard default printer. But the Excel toolbar
would now have a second print button, that would print to an alternative
printer, but leave the default printer unchanged. Thanks in advance for
whatever assistance folks can provide.