Macro to prompt printer

[jbodel]

I have a Macro in my document that prints certain pages within the workbook but I want it first to come up with a prompt that asks which printer (or in most cases, PDF)

Is this something I can easily add into my existing Macro?

 

[rollis13]

This is what you need to choose the printer.

Application.Dialogs(xlDialogPrinterSetup).Show

 

[rollis13]

Thanks for the positive feedback, glad having been of some help.