Dela via


How to: Delete Worksheets from Workbooks

You can delete any worksheet in a workbook. To delete a worksheet, use the worksheet host item or access the worksheet by using the sheets collection of the workbook.

Applies to: The information in this topic applies to document-level projects and application-level projects for Excel 2007 and Excel 2010. For more information, see Features Available by Office Application and Project Type.

Using the Worksheet Host Item

If the worksheet was added at design-time in a document-level customization, use the Delete method to delete a specified worksheet. The following code deletes a worksheet from a workbook by referencing the worksheet host item directly.

To delete a worksheet by using a worksheet host item

  • Call the Delete method of Sheet1.

    Globals.Sheet1.Delete()
    
    Globals.Sheet1.Delete();
    

Using the Sheets Collection of the Excel Workbook

Access worksheets through the Microsoft Office Excel Sheets collection in the following cases:

  • You want to delete a worksheet in an application-level add-in.

  • The worksheet that you want to delete was created at run time in a document-level customization.

The following code deletes a worksheet from a workbook by referencing the sheet through the index number of the Sheets collection. This code assumes that a new worksheet was created programmatically.

To delete a worksheet by using the Sheets collection of the Excel workbook

  • Call the Delete method of the Sheets collection.

    CType(Me.Application.ActiveWorkbook.Sheets(4), Excel.Worksheet).Delete()
    
    ((Excel.Worksheet)this.Application.ActiveWorkbook.Sheets[4]).Delete();
    

See Also

Tasks

How to: Hide Worksheets

How to: Move Worksheets Within Workbooks

How to: Select Worksheets

How to: Add New Worksheets to Workbooks

Concepts

Working with Worksheets

Worksheet Host Item

Global Access to Objects in Office Projects

Programmatic Limitations of Host Items and Host Controls