WORKBOOK.DELETE

Macro Sheets Only

Equivalent to choosing the Delete Sheet command from the Edit menu. Deletes a sheet or group of sheets from the current workbook.

Syntax

WORKBOOK.DELETE(sheet_text)

Sheet_text is the name of the sheet to delete. If omitted, the currently active sheet or sheets is deleted.

Remarks

• This function prompts for confirmation. To suppress the prompt, use the ERROR function. For example, =ERROR(FALSE).
• If the structure of the workbook is protected, you cannot delete any of its sheets.
• If you want to delete Sheet1:Sheet10, you must select them first with WORKBOOK.SELECT(). You can also place the sheets in an array first, as in {"Sheet1", "Sheet2", "Sheet3",...}.
• You cannot delete the last visible sheet in a workbook.

Related Functions

List of Command-Equivalent Functions