Dear Demigods
I have a macro attached to a button that converts to PDF and emails the sheet automatically - Button A for example purposes.
I then have another button, which is the print button - Button B.
If click I click Button A first, then click Button B, it prints as PDF.
I need a bit of code that will change Button B back to the default printer being used, before printing out without prompts.
Hope that makes sense
Thanks for your time
Regards
manc![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I have a macro attached to a button that converts to PDF and emails the sheet automatically - Button A for example purposes.
I then have another button, which is the print button - Button B.
If click I click Button A first, then click Button B, it prints as PDF.
I need a bit of code that will change Button B back to the default printer being used, before printing out without prompts.
Hope that makes sense
Thanks for your time
Regards
manc