Microsoft KB Archive/234258

= XL2000: Displayed UserForm Does Not Allow Interactivity with Workbook =

Article ID: 234258

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q234258



SYMPTOMS
When you display a UserForm in Microsoft Excel, you are not allowed to interact with the workbook even though you have enabled interactivity through a Microsoft Visual Basic for Applications macro.



CAUSE
This problem occurs if your macro sets the Interactive property to True, for example Application.Interactive = True but the ShowModal property of the UserForm is set to True, which disables interactivity.



WORKAROUND
To work around this problem, use the ShowModal property instead of the macro code to make the user form interactive. To do this, follow these steps:
 * 1) In Microsoft Excel, press ALT+F11 to activate the Visual Basic Editor.
 * 2) If the Properties window is not displayed, press F4 or click Properties Window on the View menu.
 * 3) In the Properties window, click the box to the right of the ShowModal property.

NOTE: You can find the ShowModal property alphabetically on the Alphabetic tab, or under the Behavior category on the Categorized tab.
 * 1) Click the drop-down arrow for the ShowModal property, and then click False.



MORE INFORMATION
In earlier versions of Microsoft Excel, user forms were always modal, meaning interactivity with the workbook was never allowed when the user form was displayed. In Excel 2000, you can specify interactivity with the workbook through the ShowModal property.

When creating a user form, ShowModal is set True by default, which does not allow interactivity. When the ShowModal property is set to False, interactivity is allowed.

