Window.ScrollWorkbookTabs (Excel)

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

ScrollWorkbookTabs (Sheets, Position)

ActiveWindow.ScrollWorkbookTabs position:=xlLast

Arguments

Optional arguments

The following arguments are optional

Sheets (Long) - 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 (Long) - 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.