Suppressing prompt to save workbook AFTER runtime

[stefankemp]

Hi, in my VBA code I save a workbook but leave it open. Once the code has completed and I then manually close the workbook, it asks me if I want to save the workbook, even though that is the last thing I did in my code. Any suggestions of how to avoid this?

 

[VoG]

You could try something like this after saving

ActiveWorkbook.Saved = True

 

[stefankemp]

Hmm, I though that would work but alas it didn't.