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
Return to index