HotXLS Docs
Main Index Overview

TabRatio property

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

Syntax

property TabRatio: Integer;

Notes

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. Employ FirstSheet to choose which sheet tab appears first in that tab bar, and employ 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;