Microsoft 365 and Office | Development | Other
Building custom solutions that extend, automate, and integrate Microsoft 365 apps.
BUG: Excel VBA Application.Interactive Fails
john weiss
26
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.
Microsoft 365 and Office | Development | Other
Developer technologies | Visual Basic for Applications
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
{count} votes
-
Viorel 125.7K Reputation points2021-06-22T11:10:26.397+00:00 Maybe it is related to "except input to dialog boxes that are displayed by your code".
-
john weiss 26 Reputation points
2021-06-22T11:39:07.237+00:00 That dialog box isn't displayed by my code.
-
Viki Ji_MSFT 4,471 Reputation points2021-06-23T01:27:42.417+00:00 @john weiss ,
Based on your description, your issue is more related to VBA code, as the tag office-excel-itpro focuses on general issues about Excel client, I will remove it. Thanks for your understanding!
Sign in to comment
Sign in to answer