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).
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.