Macro Sheets Only
Equivalent to selecting the Options button in a workbook contents window in Microsoft Excel version 4. This function is for compatibility with Microsoft Excel version 4. To change the name of a sheet in Microsoft Excel version 5, 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. In Microsoft Excel version 5, returns an error if FALSE.
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 document
WORKBOOK.NAME Changes the name of a sheet in a workbook
WORKBOOK.SELECT Selects the specified documents in a workbook
List of Command-Equivalent Functions