BUG: Excel VBA Application.Interactive Fails

john weiss 21 Reputation points
2021-06-22T09:41:19.203+00:00

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).
https://learn.microsoft.com/en-us/office/vba/api/excel.application.interactive

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.

108142-screenshot-40.png

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