The following below displays a message when a workbook is closed. However if
the user hits the cancel button when prompted with the options prior to
close, this code still creates the message. This is becuase this event is
triggered before the user is presented with the close options. How do you
get around this. Is there another event that I can use to verify if in fact
the file has been closed.


Private Sub Workbook_BeforeClose(Cancel As Boolean)

If Cancel = False Then
Msgbox("Book closed")
End If

End Sub