WORKBOOK.OPTIONS macro

Equivalent to selecting the Options button in a workbook contents window in Microsoft Excel version 4.0. This function is for compatibility with Microsoft Excel version 4.0. To change the name of a sheet in Microsoft Excel version 5.0, use the WORKBOOK.NAME function.

Syntax

WORKBOOK.OPTIONS(sheet_name, bound_logical, new_name)

Sheet_name    is the name of a sheet.

Bound_logical    is for compatibility with Microsoft Excel version 4.0. In Microsoft Excel version 5.0 and later versions, this should be TRUE or omitted because FALSE returns an error.

New_name    is the sheet name to assign to sheet_name. If new_name is omitted, then the sheet name is not changed.

Related Functions

GET.WORKBOOK   Returns information about a workbook sheet

WORKBOOK.NAME   Changes the name of a sheet in a workbook

WORKBOOK.SELECT   Selects the specified sheets in a workbook

Return to index