Microsoft KB Archive/113856

= Microsoft Knowledge Base =

XL: Correct TabRatio Default Value Is .60
Last reviewed: March 27, 1997

Article ID: Q113856

5.00 7.00 | 5.00

WINDOWS  | MACINTOSH kbother kbdocerr

The information in this article applies to:


 * Microsoft Excel for Windows, version 5.0
 * Microsoft Excel for the Macintosh, version 5.0
 * Microsoft Excel for Windows 95, version 7.0

SUMMARY
In Microsoft Excel, the Visual Basic Help incorrectly states that the default value for the TabRatio property of a Window is 0.75. The correct value is 0.60.

MORE INFORMATION
The TabRatio property of a window sets the ratio of the sheet tab region to the width of the document window. To verify the default value for this width, do the following:

 Open a new workbook. Insert a Visual Basic module. From the View menu, choose Debug Window.  In the Immediate pane, type the following: ?ActiveWindow.TabRatio  Press ENTER.

The value 0.6 should be displayed. This is the correct default value for the TabRatio property.