Cannot Generate Static Custom Dialog Boxes (105413)



The information in this article applies to:

  • Microsoft Excel for Windows 5.0
  • Microsoft Excel for Windows 5.0c
  • Microsoft Excel for Windows 95
  • Microsoft Excel for the Macintosh 5.0
  • Microsoft Excel for the Macintosh 5.0a
  • Microsoft Excel for Windows NT 5.0
  • Microsoft Excel 97 for Windows
  • Microsoft Excel 98 Macintosh Edition

This article was previously published under Q105413

SUMMARY

In the versions of Microsoft Excel listed at the beginning of this article, it is not possible to generate a static, or unmovable, custom dialog box.

MORE INFORMATION

By design of the custom dialog box system in Microsoft Excel versions 5.0 and 7.0, it is not possible to generate a static dialog box. Therefore, you cannot prevent a user from moving a dialog box by dragging the box's title bar.

Additionally, you can use the DialogFrame.Left and DialogFrame.Top properties 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.


Modification Type:MinorLast Reviewed:8/15/2005
Keywords:KB105413