UsableHeight Property

Applies To

Application Object, Window Object.

Description

Returns the height of the space that can be used by a window in the application window area (the window is not maximized). The height is returned in points (1/72 inch). Read-only.

Remarks

Adding a toolbar reduces the usable height.

See Also

UsableWidth Property.

Example

This example expands the active window to the maximum size available (assuming that the window is not already maximized).

With ActiveWindow
    .WindowState = xlNormal
    .Top = 1
    .Left = 1
    .Height = Application.UsableHeight
    .Width = Application.UsableWidth
End With