I have access to two printers. I standardly use printer A, and typicaly hit
PRINT or use the print button to print to the A printer. However, I'd like
to set up a button in the Excel toolbar to print to the B printer when
necessary. I know this is possible (and I've tried it). However, the
problem is that when I click on the Printer B button, it changes the
"default" printer in Excel to the B printer. I'd like to have the A printer
always be the default printer and have the B Printer button just print to
printer B and NOT change the default printer away from Printer A. Can anyone
assist? Or am I stuck using a macro to do this? Thanks very much for any
assistance.