Selecting Default Printer in a Macro

Hi everyone,

I have a form control set up as a PRINT button.

Normally, if I click it, it prints the worksheet from my active printer, which is also my default printer. This is my desired outcome.

However, if i have saved a PDF of the worksheet before using the PRINT button, my PDF printer will be the current active printer. Therefore, clicking my PRINT button will create a PDF as opposed to sending the worksheet to my default printer.

Can anyone suggest a way that I can avoid this happening? I don't want to have to specify the default printer's name in the macro as it will be used on ther user's systems who would obviously have different brands/models of printers.

Any help appreciated.

Andy

maybe you can use this in your code:

Please Login or Register  to view this content.

Thanks SjonR, but this generates a dialog box which I would like to avoid if possible.

Thanks bakerman2, what's an API call and how do i do this?

Thanks DominicB, that's a great solution!