Microsoft KB Archive/100360

{| = APP.SIZE Returns Error When Document Window Is Maximized =
 * width="100%"|

Last reviewed: June 30, 1997

Article ID: Q100360 The information in this article applies to:
 * Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a

SUMMARY
The APP.SIZE function may return a #VALUE! error if the Microsoft Excel window is maximized.

In the Microsoft Windows operating system, a window cannot be resized that is already maximized or minimized. To use APP.SIZE correctly, you must first restore the window. In an Excel macro, to restore a window, use the APP.RESTORE function.

The following sample macro illustrates the use of the APP.RESTORE and APP.SIZE functions to size the Windows Control Panel application window:

A1:=EXEC("control.exe") A2:=APP.ACTIVATE("Control Panel") A3:=APP.RESTORE A4:=APP.SIZE(200,200) A5:=RETURN