How to: Delete a Worksheet
This example demonstrates how to remove a worksheet from a workbook by calling the WorksheetCollection.Remove or WorksheetCollection.RemoveAt method of the WorksheetCollection object that is accessed via the Workbook.Worksheets property.
// Delete the "Sheet2" worksheet from the workbook. workbook.Worksheets.Remove(workbook.Worksheets["Sheet2"]); // Delete the first worksheet from the workbook. workbook.Worksheets.RemoveAt(0);
You can also hide a worksheet. See the How to: Show and Hide a Worksheet topic for details.
A workbook must always contain at least one visible worksheet.