Hi,

Just a general question. I have an add on which allows users to document a workbooks content, purpose etc. I'd like to set a message box to show if the user hasn't performed the documenting therefore I would anticipate using the following code:

Private Sub Workbook_BeforeClose(Cancel As Boolean)

If Not SheetExists("MySheet") Then
Msgbox "Please Document the Spreadsheet Contents
End If

End Sub
My question is, how do I get the code to run when a workbook closes given that the add on will be running with lots of new workbooks.

Thanks for your help in advance

M