Force save Excel 2016 to variable filename and xlsm format

Hi All,

I have this code working if the user clicks the save icon, but not if the user goes to "File > Save As". I'd like it to work the same way for both. Here is the code:

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Any help would be greatly appreciated!
Kathy B.

When I use your code, it runs when the user goes to File > SaveAs. It fires when the user selects a folder from the SaveAs dialog box. I can test your actual file if you attach it. Under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

I don't see what you are trying to accomplish with the SaveAsUI argument by immediately setting it to True, then using an If statement to test its value, which of course is going to be True. If you always want to take this action no matter how the user is saving the file, then you don't want an If statement.