ActivateWorksheet ( Worksheet worksheet ) { Debug.Assert(worksheet != null); AssertValid(); ExcelActiveWorksheetState oExcelActiveWorksheetState = GetActiveWorksheetState(); ExcelUtil.ActivateWorksheet(worksheet); return(oExcelActiveWorksheetState); }
Restore ( ExcelActiveWorksheetState excelActiveWorksheetState ) { Debug.Assert(excelActiveWorksheetState != null); AssertValid(); Worksheet oWorksheetToActivate = excelActiveWorksheetState.ActiveWorksheet; if (oWorksheetToActivate != null) { ExcelUtil.ActivateWorksheet(oWorksheetToActivate); } m_oWorkbook.Application.ScreenUpdating = excelActiveWorksheetState.ScreenUpdating; }
//************************************************************************* // Method: Restore() // /// <summary> /// Activates the worksheet that was active before <see /// cref="ActivateWorksheet" /> or <see cref="GetActiveWorksheetState" /> /// was called. /// </summary> /// /// <param name="excelActiveWorksheetState"> /// The object that was returned by <see cref="ActivateWorksheet" />. /// </param> /// /// <remarks> /// Excel's screen updating is turned back on if it was on before <see /// cref="ActivateWorksheet" /> was called. /// </remarks> //************************************************************************* public void Restore( ExcelActiveWorksheetState excelActiveWorksheetState ) { Debug.Assert(excelActiveWorksheetState != null); AssertValid(); Worksheet oWorksheetToActivate = excelActiveWorksheetState.ActiveWorksheet; if (oWorksheetToActivate != null) { ExcelUtil.ActivateWorksheet(oWorksheetToActivate); } m_oWorkbook.Application.ScreenUpdating = excelActiveWorksheetState.ScreenUpdating; }