Add ability to run confirmation prompt from macro (and if possible, make further execution of macro depending on user response) #10766
ADMIN RESPONSE
Aug 28, 2020
In 2020.3, we introduced Actions. Actions cover many typical macro use cases and can optionally use confirmation dialogs that can be fully parameterised.
In general it should be possible to insert certain points within the macro where it is interrupted and is able to process user interaction as well as updating of the spreadsheet (visible to the user) ..and then continue to run.
At the moment a macro runs in just one block from start to the end. You do cell changes during execution, which will be immediatelly visible to the user.
So for example today is not possible to show intermediate status information to the user about steps which already have been passed during the macro execution.
Like:
..preparation done..
..elements created..
..calculation running..
...
In general it should be possible to insert certain points within the macro where it is interrupted and is able to process user interaction as well as updating of the spreadsheet (visible to the user) ..and then continue to run.
At the moment a macro runs in just one block from start to the end. You cannot do cell changes during execution, which will be immediatelly visible to the user.
So for example today is not possible to show intermediate status information to the user about steps which already have been passed during a long-running macro execution.
Like:
..preparation done..
..elements created..
..calculation running..
...