WORKBOOK.ACTIVATE macro

Equivalent to activating a worksheet by clicking on its tab.

Syntax

WORKBOOK.ACTIVATE(sheet_name)

Sheet_name    is the name of the sheet you want to activate. You can use WORKBOOK.ACTIVATE to activate a sheet within the active workbook, or you can also activate a sheet in another workbook by using the [workbook]sheet_name reference for the sheet_name argument.

Related Functions

WORKBOOK.SELECT   Selects one or more sheets for group editing

WORKBOOK.OPTIONS   Changes the settings of a workbook sheet

Return to index