Suppose you have to run multiple macros on your document, multiple times.

For each of them you need to:
1) Go to Tools - Macros - Run Macro (this opens the Macro Selector dialog)
2) Then you need to Navigate to the desired macro using the Library and Macro Name areas in the dialog (note that by default no macro is selected, even if you ran a macro previously). So the user must navigate to the desired macro every time.
3) Select the macro and click Run
4) This will close the dialog window and run the macro

This workflow is OK if you run macros very rarely. But if you need to run various macros multiple times, it becomes very cumbersome.

One way to improve this would be to remember the previously selected macro, so that the previously used Library and Macro Name would be automatically selected the next time you open the Macro Selector dialog. This has already been requested in bug 145978.

In this enhancement request, I would like to propose an additional approach. We could have a checkbox named "[X] Close dialog after execution" in the dialog, which would be checked by default to replicate the current behavior of the dialog. However, if this option is unchecked, the selected macro is executed but the dialog stays open so that another macro can be selected and run.

I would like to propose 3 additional items for this enhancement proposal:
1) The checkbox state needs to be saved and remembered the next time you open the dialog (and the next time you open LO)
2) This dialog could be made non-modal so that the user can run macros and edit the sheet more quickly
3) The feature proposed in bug 145978 should also be implemented, so that each time we open the dialog, it remembers the previously selected library and macro.