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