Yields or sets the 1-based index of the active worksheet in a classic XLS workbook. Read/write Integer
Syntax
property ActiveSheetIndex: Integer;
Notes
Setting this property activates the worksheet at the specified 1-based index and updates the active tab saved in the BIFF WINDOW1 record. Invalid indexes are ignored. Employ
FirstSheet separately to control which sheet tab appears at the left edge of the tab bar
Example
This example saves the workbook so the third worksheet opens as the active sheet
Workbook.ActiveSheetIndex := 3;
Workbook.SaveAs('C:\Reports\book.xls');
See also