Window.ScrollWorkbookTabs method (Excel)
Scrolls through the workbook tabs at the bottom of the window. Doesn't affect the active sheet in the workbook.
Syntax
expression.ScrollWorkbookTabs (Sheets, Position)
expression A variable that represents a Window object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Sheets | Optional | Variant | The number of sheets to scroll by. Use a positive number to scroll forward, a negative number to scroll backward, or 0 (zero) to not scroll at all. You must specify Sheets if you don't specify Position. |
| Position | Optional | Variant | Use xlFirst to scroll to the first sheet, or use xlLast to scroll to the last sheet. You must specify Position if you don't specify Sheets. |
Return value
Variant
Example
This example scrolls through the workbook tabs to the last sheet in the workbook.
ActiveWindow.ScrollWorkbookTabs position:=xlLast
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.