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

Which version of Excel and printer are you using?

Irene said:

Which version of Excel and printer are you using?

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

Durahl said:

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

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