Hi Colin,

See attached. While originally developed a couple of years ago, I updated w/handling for SaveAs after your advisement as to your source and reviewing that.

Anyways - ours already had BeforeClose events handled, which you referenced as problematic. (I duplicated and observed the same loop, as to the repeated "do you want to save...?")

Also handled are a couple of issues we had run into, such as that when a "manual" save is executed (that is, the Save icon is pressed, or Ctrl+s) it would work fine, but if the Save was executed programatically (that is, ThisWorkbook.Save or similar is run), then the file would not actually save!

This and a couple of errors encountered occassionally are addressed and commented on in the example.

Hope this helps! I dread saying this, but so far, I haven't found a way the end user could easily get around it :-)

Mark