Workbook BeforeClose Question

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

Originally Posted by royUK

Where is MySheet? Your code will only work if it's in the workbook that contains the close event code

Hi Roy,

Yes that's my problem, the MySheet will be in the target workbook. I need to place the code in the target workbook somehow. This is the bit I'm struggling with

Cheers

Mike