Printer select code help please.

I have some code that directs print to a specific printer, how do I set it so it opens the printer dialoge window so we can select printer and properties?

Thanks

Please Login or Register  to view this content.

I replaced the "Application.ActivePrinter" line with "Application.Dialogs(xlDialogPrint).Show"
This is sort of what I'm after but can I default it to print the selction not the active sheet? When the printer dialog box opens it defaults to print active sheet, I'd like it to default to active selection...

Idea's please.

Please Login or Register  to view this content.