selecting printer

G

Guest

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
 
P

Paul B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top