Print to PDF - Error Read Only

[jsherwood]

Below is some code to print the active sheet to a PDF, works great. The issue is if the user leaves the PDF viewer open and clicks to print again I get an error, see below. Can anyone help with stopping the macro from running to prevent an accidental error?

Capture.PNG

Please Login or Register  to view this content.

[shg]

Please Login or Register  to view this content.

[jsherwood]

I am fairly new to VBA, inserted the code and can tell it works great. From the way its acting I am guessing its inserted in the wrong spot. Can you combine it all so I can copy and insert?

[jsherwood]

Think I got it, seems to be working well!

Please Login or Register  to view this content.

[jsherwood]

Follow up question on this. Code works well, except if you have your PDF program open it will not print without closing it. Example would be if I have another pdf open and viewing, try to print with this macro it throws the error msgbox. Can that we corrected?

[shg]

You can't overwrite an open file.

EDIT: That's not strictly true; I think you could overwrite a file open in Notepad. But most applications lock files when opening them.