Hi Guys,
I am executing a macro using the “Run Macro” command in the Excel Advanced package & facing an issue where the macro is getting executed without any issues but at the end a dialog box comes up which indicates that the macro was successfully executed. It is due to the MsgBox command present at the end of the macro code.
When the pop up comes up, it does not closes automatically as well as the subsequent lines of code do not get executed in AA & the the code is stuck at “Run Macro” command till someone manually click on the OK button of the dialog box.
Can anyone please help me to overcome this issue?
