Stop the "Do you want to save changes" prompt

[groston]

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

MyNewWorkbook.Saved = True


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?

[June7]

Try just:

MyNewWorkbook.Save

But if this is a new workbook, probably need SaveAs to designate destination.

[groston]

The line of code I showed is the line after the MyNewWorkbook.Save line. It was a failed attempt at addressing the issue.

[Jan Karel Pieterse]

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.

[groston]

Gotcha. Currently, there are some erase lines after that.