Printer Selection Box

[Susan Lund]

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

 

[Tom Ogilvy]

Application.Dialogs(xlDialogPrinterSetup).Show

 

[Tom Ogilvy]

Another option is:

Application.Dialogs(xlDialogPrint).Show

but that would be less specific.

 

[Susan Lund]

Yes, thank you for your help. That's exactly what we were
looking for!