HotXLS Docs
Home Contents Overview

TabRatio property

Returns or sets the workbook tab bar ratio in a classic XLS workbook. Read/write Integer.

Syntax

property TabRatio: Integer;

Remarks

The value controls the relative width reserved for sheet tabs versus the horizontal scrollbar. Valid values are 0 through 1000; Excel's default is 600. Use FirstSheet to choose which sheet tab appears first in that tab bar, and use ShowSheetTabs to hide or show the tab bar.

Example

This example gives the sheet tab area more room in the workbook window. 

Workbook.TabRatio := 720;