Excel VBA App stops spontaneously with message Code execution has been halted

0 votes
We have several Excel VBA applications that run flawlessly on a variety of users' computers. On one machine, though, they halt at specific lines of code. It always has the same lines, but they don't seem to be connected in any way.

After the halt, the software resumes if you press F5 (run), thus it's almost like a breakpoint has been added. We've attempted to add breaks and then remove them again, as well as choosing "remove all breaks" from the menu. Previously, when this problem affected a single app, we 'bodged' it by removing code from modules, compiling it, and then pasting it back in, etc.

We're not entirely sure how to handle this since the issue now appears to be with Excel as a whole rather than a specific.xls file.
Sep 26, 2022 in Others by Kithuzzz
• 27,360 points
123 views

2 answers to this question.

0 votes

We have a number of Excel VBA apps which work perfectly. You could write VBA code based on the Change event in the worksheet.  You could write VBA code based on the Change event in the worksheet.

answered Sep 28, 2022 by anonymous
• 140 points
0 votes

Solution

  1. Press the "Debug" button in the popup.
  2. Press Ctrl+Pause|Break twice.
  3. Hit the play button to continue.
  4. Save the file after completion.
answered Sep 29, 2022 by narikkadan
• 50,440 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

Expected response code 250 but got code "530", with message "530 5.7.1 Authentication required

Your mail.php on config you declare host ...READ MORE

answered Feb 16, 2022 in Others by Aditya
• 7,660 points
707 views
0 votes
1 answer

How to print an Excel Sheet using VBA with Nitro PDF Creator in Excel 2016

you can use the built-in excel facilities ...READ MORE

answered Sep 24, 2022 in Others by narikkadan
• 50,440 points
220 views
0 votes
1 answer

Hosting Microsoft Edge via WebView2Loader.dll with Excel VBA

Here's an API to communicate with Chromium ...READ MORE

answered Sep 29, 2022 in Others by narikkadan
• 50,440 points
636 views
0 votes
1 answer

Unhide rows in Excel with VBA

Paste this code into a module of ...READ MORE

answered Oct 1, 2022 in Others by narikkadan
• 50,440 points
140 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
519 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
2,374 views
0 votes
1 answer

Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 22,940 points
110 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,640 points
272 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP