Microsoft KB Archive/100360: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 20: | Line 20: | ||
The following sample macro illustrates the use of the APP.RESTORE() and APP.SIZE() functions to size the Windows Control Panel application window: | The following sample macro illustrates the use of the APP.RESTORE() and APP.SIZE() functions to size the Windows Control Panel application window: | ||
<pre> A1:=EXEC( | <pre> A1:=EXEC("control.exe") | ||
A2:=APP.ACTIVATE( | A2:=APP.ACTIVATE("Control Panel") | ||
A3:=APP.RESTORE() | A3:=APP.RESTORE() | ||
A4:=APP.SIZE(200,200) | A4:=APP.SIZE(200,200) | ||
Line 28: | Line 28: | ||
== REFERENCES == | == REFERENCES == | ||
"Function Reference", version 4.0, pages 21-22 "Function Reference", version 3.0, pages 12-13 | |||
|} | |} | ||
Latest revision as of 12:39, 19 July 2020
APP.SIZE() Returns Error When Document Window Is MaximizedLast reviewed: June 30, 1997 |
The information in this article applies to:
SUMMARYThe 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() REFERENCES"Function Reference", version 4.0, pages 21-22 "Function Reference", version 3.0, pages 12-13 |
Additional reference words: 3.00 4.00 4.00a resize change Last reviewed: June 30, 1997 |