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

ID: Q215861

The information in this article applies to:

Microsoft Excel 2000

SYMPTOMS

When you display a UserForm in Microsoft Excel, you can still interact with the workbook even though you have turned off interactivity by setting the ShowModal property to True.

CAUSE

This problem occurs when you have a Microsoft Visual Basic for Applications macro which contains code similar to the following behind the user form:


Application.Interactive = False
Application.Interactive = True

When you set Application.Interactive to False and then True, it overcomes the ShowModal property setting of True.

WORKAROUND

To work around this problem, do not use the Application.Interactive property to control interactivity with the user form. Instead, use only the ShowModal property. To use the ShowModal property, 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 the appropriate setting.

When the ShowModal property is True, interactivity is disabled. When the ShowModal property is False, interactivity is enabled.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes that you are familiar with the programming language being demonstrated and the tools used to create and debug procedures. Microsoft support professionals can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific needs. If you have limited programming experience, you may want to contact a Microsoft Certified Solution Provider or the Microsoft fee-based consulting line at (800) 936-5200. For more information about Microsoft Certified Solution Providers, please see the following page on the World Wide Web:

http://www.microsoft.com/mcsp/

For more information about the support options available from Microsoft, please see the following page on the World Wide Web:

http://www.microsoft.com/support/supportnet/overview/overview.asp

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 and through code.

When creating a user form, ShowModal is set to True by default, which does not allow interactivity. When the ShowModal property and the interactivity code conflict, the ShowModal property usually takes precedence. You can override this precedence in a Visual Basic for Applications macro by first setting the interactivity equal to the ShowModal setting and then setting interactivity to the setting you want. The following macro code disables interactivity


Application.Interactivity = False

and the following macro code enables interactivity:


Application.Interactivity = True

When the ShowModal property is True, interactivity is disabled. When the ShowModal property is False, interactivity is enabled.

REFERENCES

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

Q234258 Displayed UserForm Does Not Allow Interactivity with Workbook

Additional query words: XL2000

Keywords :
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug