Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Sizes the specified task window.
Syntax
expression.Resize (Width, Height)
expression Required. A variable that represents a 'Task' object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Width | Required | Long | The width of the window, in points. |
| Height | Required | Long | The height of the window, in points. |
Remarks
If the window is maximized or minimized, using this method causes an error. Use the Width or Height property to set the window width and height independently.
Example
This example resizes the Microsoft Excel application window to 6 inches wide by 4 inches high.
If Tasks.Exists("Microsoft Excel") = True Then
With Tasks("Microsoft Excel")
.WindowState = wdWindowStateNormal
.Resize Width:=InchesToPoints(6), Height:=InchesToPoints(4)
End With
End If
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.