XL2000: Displayed UserForm Does Not Allow Interactivity with Workbook (234258)

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:

In Microsoft Excel, press ALT+F11 to activate the Visual Basic Editor.
If the Properties window is not displayed, press F4 or click Properties Window on the View menu.
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.
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.

REFERENCES

For additional information about user forms and interactivity, please see the following article in the Microsoft Knowledge Base:

215861 XL2000: Displayed UserForm Allows Interactivity When ShowModal Property Is Set to True