Excel Workbook Close Event__ Documentation Proof needed.

[Naveen.Kasha]

Hi All,

I need a documentation proof for the following observation i have
made(presuming my observations are correct )

I have written a addin for Microsoft Excel.
This addin handles the CLOSE event from the Excel.
But now , I have a Macro in an Excel sheet which is also listening for
the close event.(the macro is as below)

Private Sub Workbook_BeforeClose(Cancel As Boolean)
If MsgBox("Confirm exit", vbYesNo) = vbNo Then
Cancel = True
End If
End Sub


And in the Addin , i am using the Cancel parameter as below.

OnWorkbookBeforeClose(IDispatch* pWorkbook, VARIANT_BOOL* pbCancel)
{

//So here pbCancel value is depending on what is clicked in that
message box --
// As it is seen Message box has two buttons "Yes" and "No"
// If "No" button is clicked , the Cancel parameter value we get is
"True"
// If "Yes" button is clicked, the addin does what is intend it to do.
(i:e it closes the Excel)
}


As it is understood
This macro pops up a message box and can alter the "cancel" depending
on what is clicked.
And in the Addin,
what i get now is the edited value of the "Cancel" parameter if "NO"
button is clicked.

So, what i am assuming is, THE EVENT FIRST GOES TO THE MACRO AND ONLY
THEN COMES TO MY ADDIN.

So, is my assumption Correct, if so , can i have some Documentation
proof for the same(i:e - The control goes to the macro first and then
will be sent to the Addin's (if any))

So, has any one come across the same situation.
It would be of great help if you reply me on this.
Thanks in Advance.
Naveen