I wouldn't do this.

You may find that a user deleted way too much (on purpose or by accident) and
wants to close the file without saving.

If you make the save automatic, then you'll have a different problem--maybe
worse (depending on the changes and the state of your backups).



Kathy Love wrote:

Need to find "fool-proof" method of ensuring Users save Excel workbooks
before exiting program. This has been a huge problem in the past. Can this
be done with a macro?

--

Dave Peterson