Print Documents on predefined Printer ( not System Default ), how?

[Durahl]

Hi there!

Question:
Is there a way to have a Document to be printed on a predefined Printer NOT beeing the System Default one?

Let me explain:
We're using an Excel that needs to be filled with Information which then fills the gaps in a special designed Paper we used with our old Printer.

As of recently we aquired a 2nd Printer ( System Default ) which is having problems with the special Paper so we have to use the old one but the one person which handles this work is a little overwhelmed when it comes to switching Printers.

( I know... it's just one click but meh... )

Thanks in advance for any help ¦:}

 

[Irene]

Which version of Excel and printer are you using?

 

[Irene]

Which version of Excel and printer are you using?

Also, perhaps you could create a macro and assign a button for the User?

 

[richnrockville]

Hi there!

Question:
Is there a way to have a Document to be printed on a predefined Printer NOT beeing the System Default one?

Let me explain:
We're using an Excel that needs to be filled with Information which then fills the gaps in a special designed Paper we used with our old Printer.

As of recently we aquired a 2nd Printer ( System Default ) which is having problems with the special Paper so we have to use the old one but the one person which handles this work is a little overwhelmed when it comes to switching Printers.

( I know... it's just one click but meh... )

Thanks in advance for any help ¦:}

Normally each program that you want to print in, allows you to choose which printer you can use, or it defaults to the default printer.
The only way I can see to print to a specific printer from excel is to manually select it each time. Just don't select the apply button or it will change your default to that printer.

Rich

 

[Irene]

This might help if you decide that a macro button would be useful:
Excel 2010: Using Macro Through Buttons