Window.ScrollWorkbookTabs Method

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.

Visual Basic for Applications
`ActiveWindow.ScrollWorkbookTabs position:=xlLast`

Allow user to see first tab on workbook? Move tabs over three sheets? Scroll to show last worksheet tab? scroll workbook tabs Scroll Workbook Tabs Method scrollworkbook ScrollWorkbookTabs ScrollWorkbookTabs Method

Scrolls through the workbook tabs at the bottom of the window. Doesn't affect the active sheet in the workbook.

See also: