BUG: Excel VBA Application.Interactive Fails

john weiss 21 Reputation points

Help doc states:

If you set this property to False, Excel blocks all input from the keyboard and mouse (except input to dialog boxes that are displayed by your code).

This feature is defective. During lengthy saves, a native dialog is displayed. i can click the "Cancel" button, even if Interactive is set to false.


Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,480 questions
{count} votes