WINDOW.MOVE Returns Error Message if Window Is Maximized

• Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 5.0
• Microsoft Excel for OS/2, versions 2.2, 2.21 and 3.0

SYMPTOMS

In Microsoft Excel, when you use the WINDOW.MOVE macro function, you receive a macro error if the active window or the window specified in the WINDOW.MOVE function is maximized.

NOTE: In versions of Microsoft Excel previous to version 4.0, the equivalent macro function is MOVE. This function has the same behavior.

WORKAROUNDS

• To avoid receiving the error message and move the window whether it is maximized or not, use the following command in your macro before you use the WINDOW.MOVE function:
  
  =WINDOW.RESTORE()



• To only avoid receiving the error message and not move the window when it is maximized, use the following command in your macro before you use the WINDOW.MOVE function:
  
  =ERROR(FALSE)



• To test to see whether the active window is maximized before you use the WINDOW.MOVE function, use the following command in your macro:
  
  =GET.WINDOW(20)
  
  This statement returns TRUE if the window is maximized; FALSE otherwise.

MORE INFORMATION

The WINDOW.MOVE function moves the upper-left corner of a document window to a specified horizontal and vertical position. For example, the macro command, =WINDOW.MOVE(1,1) moves the upper-left corner of the active window to the position (1,1) (measured in points).

REFERENCES

"Microsoft Excel Function Reference," Version 4.0, pages 180, 207-209, and 280.

"Microsoft Excel Function Reference," Version 3.0, pages 98, 115-116, and 156-157.

"Microsoft Excel Function Reference" for Windows, Version 4.0, page 280

Additional query words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 4.0 5.0

Keywords :
Version :
Platform :
Issue type :