Applies To
Window Object.
Description
Scrolls the workbook tabs at the bottom of the window. Does not affect the active sheet in the workbook.
Syntax
object.ScrollWorkbookTabs(sheets, position)
object
Required. The Window object.
sheets
Optional. The number of sheets to scroll. Positive means scroll forward, negative means scroll backward, zero means don't scroll. You must specify sheets if you do not specify position.
position
Optional. xlFirst to scroll to the first sheet, or xlLast to scroll to the last sheet. You must specify position if you do not specify sheets.
Example
This example scrolls the workbook tabs to the last sheet in the workbook.
ActiveWindow.ScrollWorkbookTabs position:=xlLast