Excel: xy Coordinates Ignored for Triggered, Movable Dialog

Last reviewed: July 16, 1997
Article ID: Q84019
The information in this article applies to:
  • Microsoft Excel for the Macintosh, versions 3.0, 4.0
  • Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a

SUMMARY

A floating dialog box that is displayed as a result of a trigger item from another floating dialog box is displayed with its upper-left corner aligned to that of the first dialog box. That is, the x and y coordinates in the second floating dialog box description are ignored.

To work around this problem, change the type of either dialog box to the non-movable variety.

MORE INFORMATION

A movable dialog box is designated by typing a name in the text column (column 6) of the first row of a dialog box definition table. To change a movable dialog box to a fixed dialog box, remove this text.

Under normal circumstances, the placement of a dialog box can be controlled by entering x and y coordinates into the fourth and fifth columns of the first line of the dialog box description table. If these coordinates are left out, the dialog box will be centered on the monitor when it is displayed.

To specify a trigger items, add 100 to the item number in the dialog box definition table.

REFERENCES

"User's Guide 2," version 4.0, pages 272-282 "User's Guide," version 3.0 for the Macintosh, pages 628-636 "Microsoft Excel User's Guide," version 3.0 for Windows, pages 631-640


Additional query words: 3.0 3.00 4.0 4.00 dialogue sticky


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: July 16, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.