HotXLS Docs

FirstSheet property

Yields or sets the first visible sheet tab in a classic XLS workbook. Read/write Integer

Syntax

property FirstSheet: Integer;

Notes

The value is 1-based and must refer to an existing worksheet. This property controls which sheet tab appears at the left edge of the tab bar when Excel opens the workbook; employ TabRatio to adjust the relative width of the tab bar, and employ ActiveSheet or Activate to choose the active sheet

Example

This example scrolls the workbook tab bar so the third sheet tab is first visible

Workbook.FirstSheet := 3;