selecting printer
 

Hi, I am looking for a way to select a printer when code is run. This file
may be run from different computers which have access to different printers.
I'm wondering what the best way is to have the printer window appear and
allow the user to choose their printer?? Thanks much

selecting printer
 

Aaron, try one of these

Application.Dialogs(xlDialogPrint).Show

Application.Dialogs(xlDialogPrinterSetup).Show


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Aaron" wrote in message
...
Hi, I am looking for a way to select a printer when code is run. This
file
may be run from different computers which have access to different
printers.
I'm wondering what the best way is to have the printer window appear and
allow the user to choose their printer?? Thanks much