private void OnWorksheetDeleted(WorksheetDeletedEventArgs e) { var handler = WorksheetDeleted; if (handler != null) { handler(this, e); } }
void Application_SheetActivate(object sh) { var ws = sh as Excel.Worksheet; var wb = ws.Parent as Excel.Workbook; // A worksheet was closed if a request is pending and the worksheet count decreased var wasClosed = PendingRequest != null && wb.Worksheets.Count < PendingRequest.WorksheetCount; if (wasClosed) { var args = new WorksheetDeletedEventArgs(PendingRequest.WorksheetName, PendingRequest.WorkbookName); PendingRequest = null; OnWorksheetDeleted(args); } else { PendingRequest = null; } }