SAVE as PDF has a glitch {pulling hair out}

I am running an excel macro that saves it as a PDF. I want it to pop up with a default file name and ask the user if they want to overwrite it. If they say yes, then overwrite, but if they say no, then they should be prompted to change the file name. It does this, but if the user selects save again, then the file saves automatically without confirming if they want to overwrite it.

It works almost like it is supposed to, but It is doing something weird.

If you click save as, the pdf save as pops up with the default file name GOOD
If you try to overwrite the file a message box appears to verify you want to overwrite GOOD
If you click no to over write, but click save again, the message box does not appear, and it overwrites the file anyways. BAD

I have taken out all loops I was trying so it would not jumble the code up for you.



Here is a copy of the code that is whooping my butt. If you have a sec, could you take a look? I owe you big
Cross Posted on Mr. excel

Please Login or Register  to view this content.