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