Stop the "Do you want to save changes" prompt
I wrote a macro and this macro creates a new WorkBook. The last few lines in the macro are Erase lines and just before those lines, I have
However, when I click the x button in the workbook (top right corner), I get the "Do you want to save changes" prompt. Did I miss something?MyNewWorkbook.Saved = True
Try just:
MyNewWorkbook.Save
But if this is a new workbook, probably need SaveAs to designate destination.
How to attach file: Reading and Posting Messages (vbaexpress.com), click Go Advanced below post edit window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
The line of code I showed is the line after the MyNewWorkbook.Save line. It was a failed attempt at addressing the issue.
Make sure the MyNewWorkbook.Saved = True is the last line of the routine. But, if your file contains any volatile functions like TODAY, NOW or INDIRECT, there is nothing you can do to prevent this message.
Gotcha. Currently, there are some erase lines after that.
Posting Permissions
