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

See also

Window Object

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.