Select Network Printer from VBA

Hiya

I have a workbook which gets printed by other users on a monthly basis.

I have set up a print macro to print the required sheets from the workbook (not all worksheets are printed.)

Each user needs to print the workbook on their specific Network printer, sometimes on their colour printer and sometimes in black and white.

Obviously, some users have different printers on the Network, added to which, our Network is being re-organized and printer "names" are changing.

Is there any way that I can get a list of installed printers?

I can use: Application.Dialogs(8).Show to bring up the standard Print dialog which does allow me to select the printer, but does not allow me to control which worksheets are printed.

Any suggestions??

JAF