ScrollWorkbookTabs Method

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