Tap into the windows print dialog

application.Dialogs(xlDialogPrint).Show

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"fullers" wrote in message
...
I have set up a macro that will print dozens of pages after selecting the
colour printer in the office. This is done by specifying the exact printer
in
the macro itself.

I want to send this to people in different locations (these people are not
very clued up on excel). I want to allow them to print but obviously the
printer will be different.

Is there a way I can bring up a drop down box that will allow them to
select
their desired printer?

If so what would be the coding (I am only just getting into writing macros
myself).

Thanks in advance.