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.