ACTIVATE.NEXT
ACTIVATE.PREV

Macro Sheets Only

Switches to the next or previous window, respectively, or switches to the next or previous sheet in a workbook.

Syntax

ACTIVATE.NEXT(workbook_text)
ACTIVATE.PREV(workbook_text)

Workbook_text is the name of the workbook for which you want to activate a window.

• If workbook_text is specified, ACTIVATE.NEXT and ACTIVATE.PREV are equivalent to pressing CTRL+PAGE DOWN and CTRL+PAGE UP (in Microsoft Excel for Windows) or COMMAND+PAGE DOWN and COMMAND+PAGE UP (in Microsoft Excel for the Macintosh). These functions switch to the next and previous sheets, respectively.
• If workbook_text is omitted, these functions are equivalent to pressing CTRL+TAB or CTRL+SHIFT+TAB (in Microsoft Excel for Windows) or COMMAND+M or COMMAND+SHIFT+M (in Microsoft Excel for the Macintosh). These functions switch to the next and previous windows, respectively.

Related Functions

ACTIVATE Switches to a window

ON.WINDOW Runs a macro when you switch to a window

WORKBOOK.NEXT Switches to the next sheet in a workbook

WORKBOOK.PREV Switches to the previous sheet in a workbook

WORKBOOK.SELECT Select a sheet in a workbook

List of Command-Equivalent Functions