HotXLS Docs
Home Contents Overview

FirstSheet property

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

Syntax

property FirstSheet: Integer;

Remarks

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; use TabRatio to adjust the relative width of the tab bar, and use 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;