APP.SIZE() Returns Error When Document Window Is Maximized

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()

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
Keywords : kbmacro kbprg
Version : 3.00 4.00 4.00a
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: June 30, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.