Printer Selection Box
Yes, thank you for your help. That's exactly what we were
looking for!
-----Original Message-----
You might be looking for:
Application.Dialogs(xlDialogPrinterSetup).Show
"Susan Lund" wrote:
I'm working on a project that will eventually be used
by
multiple users. I have a macro to print out a
selection
of graphs, and it works great. Then I realized the
users
will need the ability to change the printer (ie: to the
color printer)instead of it just invoking the default
printer. Since each user is connected to a different
set
of printers, the only solution is to have the macro
bring
up the printer selection box before executing the print
function. Is there a way to do this?
Thanks in advance for any help I can get!
Susan
.
|