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




