Excel workbook event order and usage when closing Excel
- by mas_oz2k1
Given the following workbook events:
BeforeClose
BeforeSave
Please tell me:
- The firing order in the case of multiple workbooks alreay opened (wb1, wb2 and wb3 are opened in this order) and the user closes Excel. You can assume all 3 needs saving.
- What happen if user cancels one of the saving operations say wb2?
Note: Please provide link or sample .net code of event usage. ( I have the msdn event definition links already no need to post t them again)