Macros with confirmation dialogues
Add ability to run confirmation prompt from macro (and if possible, make further execution of macro depending on user response) #10766
This request has been added to our feature backlog.
Jens Consör commented
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.