4,383 questions
Try to press the button from the error dialog (i.e. go to Visual Basic window), then select Reset from Run menu.
Then fix the macro and re-execute it.
How can I restart the makro execution in Excel?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 83%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jan HALLER
0
Reputation points
How can I restart the makro execution in Excel if it was stopped due to an error in the makro execution (with displaying options like debug or break)? The only way I have found so far is to completely close Excel and restart it.
Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Excel | For business | Windows
3,921 questions
{count} votes
-
Emily Hua-MSFT 27,796 Reputation points2023-05-05T08:51:54.9366667+00:00 Hi,
Maybe you still need the code help.
Please checkout the thread 'How to break and restart code execution automatically in VBA? Error-Handling'.
(Please Note: Since the web site is not hosted by Microsoft, the link may changed without notice. Microsoft does not guarantee the accuracy of this information.)
Sign in to comment
2 answers
Sort by: Most helpful
-
Viorel 122.6K Reputation points2023-05-04T11:44:43.92+00:00 -
Jan HALLER 0 Reputation points
2023-05-04T15:10:59.8233333+00:00 Thanks a lot! I should try that for my own use.
But I guess my question was not precise enough. The problem is more troublesome to the less experienced users of my Excel tool. If they generate a macro crash for whatever reason they will give me a call and ask why some functionality is not working. My standard question would be whether they got a macro crash (with getting the question for debugging) and the advise to restart Excel completely. I fear the reset funtion in the VBA-editor would be too complicated for them. I am now wondering if either the halt of the macro execution (in all instances of Excel) could be prevented or the restart could be somehow automatized so that issues with my programming (I did indeed not care of catching all potential faults.) would not cause such problems.
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 18%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Tanay Prasad 2,250 Reputation points2023-05-05T04:35:45.1733333+00:00 Hi,
You can restart the macro execution in Excel by following these steps:
Press ALT + F11 to open the Visual Basic Editor.
In the Visual Basic Editor, navigate to the module that contains the macro that you want to run.
Place your cursor in the macro code where you want to restart the execution.
Press F5 or select Run from the menu bar and click Run Sub/UserForm.
When the error message appears, click on the "Debug" button.
In the Visual Basic Editor, you can now make changes to the code to fix the error.
Once you have fixed the error, you can run the macro again by pressing F5 or selecting Run from the menu bar and clicking Run Sub/UserForm.
If you want to stop the macro execution entirely, you can press the "End" button or use the shortcut key "Ctrl + Break".
Best Regarrds.