XL: Not Possible to Position Custom Dialog Boxes
ID: Q109423
|
The information in this article applies to:
-
Microsoft Excel for Windows, versions 5.0, 5.0c
-
Microsoft Excel for Windows 95, versions 7.0, 7.0a
-
Microsoft Excel for the Macintosh, versions 5.0, 5.0a
SUMMARY
In the versions of Microsoft Excel listed at the beginning of this article,
it is not possible to directly affect the on-screen position of a custom
dialog box when it is displayed.
NOTE: A note at the top of page 225 in the Visual Basic "User's Guide,"
version 5.0, states that you can cause a custom dialog box to appear at a
specific location. This information is incorrect.
MORE INFORMATION
The DialogFrame.Left and DialogFrame.Top properties can be used to change
the position within a dialog sheet of a dialog frame. However, changing
these properties does not affect the on-screen position of a custom dialog
box when you show it by using the DialogSheets("Dialog1").Show method.
In Microsoft Excel, when a dialog box is shown, its upper-left corner will
be located in the same position as the upper-left corner of the last dialog
box shown.
Other dialog boxes, such as the Open and Save As dialog boxes, follow the
same rule. For example, when the Open dialog box is visible and you choose
the OK button to remove it, the next dialog box that appears on the screen
will appear with its upper-left corner in this same position.
NOTE: If, when you display a dialog box, part or all of the dialog box is
pushed off the edge of the screen, Microsoft Excel automatically shifts the
dialog box so that the whole dialog box is visible.
Additional query words:
XL5 XL7
Keywords :
Version : WINDOWS:5.0,5.0c,7.0; MACINTOSH:5.0,5.0a
Platform : MACINTOSH WINDOWS
Issue type :