Occurs before a worksheet is removed from a workbook.
The SheetRemoving event's data class is SheetRemovingEventArgs. The following properties provide information specific to this event:
|Cancel||Gets or sets a value indicating whether the event should be canceled. Inherited from CancelEventArgs.|
The SheetRemoving event allows you to perform any actions before removing a worksheet from a workbook. You can cancel removing a worksheet by setting the event parameter’s Cancel property to true.
After a worksheet has been removed from a workbook, the Workbook.SheetRemoved event is raised.
By default, the SheetRemoving event does not occur. To trigger it, set the WorkbookEventOptions.RaiseOnModificationsViaAPI property (accessible via the Workbook.Options.Events.RaiseOnModificationsViaAPI notation) to true.