Sorry...the above still displays the "Do you want to save your changes" message when I try to close the workbook.

I tried using the same thisworkbook.saved = true

in the auto_close macro, but it did not save any changes I made to the workbook.