Skip to content

Latest commit

 

History

History
42 lines (24 loc) · 1005 Bytes

Excel.Window.TabRatio.md

File metadata and controls

42 lines (24 loc) · 1005 Bytes
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Window.TabRatio property (Excel)
vbaxl10.chm356116
vbaxl10.chm356116
Excel.Window.TabRatio
41033d2d-9967-3990-b739-61c0649c24f3
05/21/2019
medium

Window.TabRatio property (Excel)

Returns or sets the ratio of the width of the workbook's tab area to the width of the window's horizontal scroll bar (as a number between 0 (zero) and 1; the default value is 0.6). Read/write Double.

Syntax

expression.TabRatio

expression A variable that represents a Window object.

Remarks

This property has no effect when DisplayWorkbookTabs is set to False (its value is retained, but it has no effect on the display).

Example

This example makes the workbook tabs half the width of the horizontal scroll bar.

ActiveWindow.TabRatio = 0.5

[!includeSupport and feedback]