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
Bookmarks