Can Excel memorise the last printer used?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My problem is
I have 2 network printers, A and B, A is set to be the default printer.
I work on an Excel doc and choose B to print out.
I want to know how to make this file to memorise the last used printer B so
that next time I open the file it use printer B automatically.

My software is Excel 2003 on WinXP (SP2)


Best regards
Simon Wong
 
You would probably need to write code to select the printer, save that info
in the workbook, output to that printer, and reset it on next opening.
Hardly seems worth the effort to me.
 
Back
Top