Hi,

I have 2 workbooks viz workbook1 and workbook2.

I have code running ONLY in workbook1 and workbook2 is just any
workbook opened by workbook1, which contains data on which the
workbook1 works on.

At any instance, if i close workbook2 from the Close "X" button or
using the file close menu, the code in workbook1 should be able to
detect the change and STOP workbook2 from closing and instead present
a "CLOSE WORKBOOK2 - Yes/No" message box.

I need some kind of API or handle which will detect/grab the closing
of workbook2 and present the message box.

Is this possible?