I wish a message box to appear before closing an Excel Workbook,
however I have tried (in the "THIS WORKBOOK" object:

Private Sub Workbook_BeforeClose()

MsgBox "This document is now CLOSING."

End Sub

And also:

Workbook_Close

Auto_Close, none of which appear to work.

Any ideas?

Thanks

Ian M