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

Application.Dialogs(xlDialogPrinterSetup).Show

--
Regards,
Tom Ogilvy

"Susan Lund" wrote in message
...
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

Another option is:

Application.Dialogs(xlDialogPrint).Show

but that would be less specific.
--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
Application.Dialogs(xlDialogPrinterSetup).Show

--
Regards,
Tom Ogilvy

"Susan Lund" wrote in message
...
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

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

.