How do I offer a 'CANCEL' when user closes the document?

[PosseJohn]

I have a document that we update every shift of work. To preserve what 'was', in the Document Close event, I have an archive file saved with date/time in the file name, so going back to reconstruct what was documented is fairly easy.

In the Document Close event, I ask the user if they want to save changes, if yes then I have the code save the file, and then save the archive copy. If no, then I change the .Saved property to TRUE.

I would like to offer the vbYesNoCancel dialog, but I don't know how to cancel the closing event.

Any suggestions?

Thank you!

Here is the code that I am using in the Document Close event...

Please Login or Register  to view this content.

[shg]

Completely untested. In the ThisDocument module, in lieu of your existing code,

Please Login or Register  to view this content.

[PosseJohn]

I will try tonight when I return to work, THANK YOU for your contribution.