Microsoft KB Archive/79585

{|
 * width="100%"|

Excel: Part of Dialog Box with Trigger Items Is Erased

 * }

-

The information in this article applies to:


 * Microsoft Excel for the Macintosh, versions 3.0, 4.0, 5.0

-

SUMMARY
In Microsoft Excel, if you select a custom dialog box item that is a trigger, the Macintosh system may overwrite portions of the dialog box with parts of items on the desktop. Items that may be used to overwrite portions of the dialog box include title bars of windows behind the dialog box, other applications, and portions of the dialog box that overlap the desktop region.

To avoid this behavior, make sure an Excel document completely covers the region behind the dialog box. One way to do this is to open a blank worksheet and zoom (maximize) it to its full size.

If this is being done through a macro, the FULL(TRUE) macro statement can be used to zoom the active document to its full size.

Steps to Reproduce Problem
 Close all open Excel documents and create a new macro sheet.  Enter the following information into the macro sheet (leave columns C through F blank):

  A1: =DIALOG.BOX(B1:H3)  B1:        C1: A2: =IF(A1=1,GOTO(A1)) B2: 113    C2: Check box A3: =RETURN          B3: 1      C3: OK  Select cell A1 in the macro sheet and from the Formula menu, choose Define Name. Type test for the name, select the Command button, then choose the OK button. Resize the current Macro sheet so that it is very small and a good percentage of the desktop is visible. From the Macro menu, choose Run, select the test macro, and choose the OK button. Click the check box. The dialog box disappears momentarily while the macro runs. This is when the Macintosh System is drawing the desktop or the other applications running in the background over the dialog box.</ol>