Don't you already get a prompt to save the workbook if you try to close
without saving.

Regards,

OssieMac



"slavenp" wrote:

How do I set up an excel s/sheet to prompt users to save document each time
the s/sheet is closed.