I have written a macro that is tied to a clickable button. The button opens a dialog box that contains a couple of options and two buttons; one to run the macro and the other to stop the macro. I am able to click on the button to run the macro, and I can tell that the macro is working by my mouse cursor changing to the loading icon. Once the loading mouse icon disappears, the dialog box remains on the screen and nothing happens. I have to click the button to stop the macro in order to get rid of the dialog box and for the excel sheet to display the updated information that the macro processed.
How do I program the macro to automatically close the dialog box once it has finished running?
Bookmarks