Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

WorksheetBase.Shutdown Event

Occurs when the worksheet host item shuts down.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

public event EventHandler Shutdown

This is the last event to be called in the WorksheetBase class as the WorksheetBase class unloads. Use this event for any additional clean up.

In a document-level customization, the application domain for the assembly unloads when the worksheet host item shuts down.

In an application-level add-in, the application domain does not unload when the worksheet host item shuts down. Also, the underlying worksheet object is no more available. To access the worksheet before it shuts down use BeforeClose instead.

The following code example demonstrates a handler for the Shutdown event that displays a message when the WorksheetBase class unloads.

This example is for a document-level customization.

private void WorksheetShutdown()
    this.Shutdown += new EventHandler(Worksheet1_Shutdown);

void Worksheet1_Shutdown(object sender, EventArgs e)
    MessageBox.Show(this.Name + " is shutting down.");

© 2015 Microsoft