Error message, "Can't execute code in break mode" when stepping through a procedure

[USAMax]

I have not setup any error trapping. I am just stepping through a macro that I have been working with for about a year. Now, during most commands I get the message, "Can't execute code in break mode".

How do I turn this off so it doesn't keep prompting me?

 

[JLGWhiz]

I have not setup any error trapping. I am just stepping through a macro that I have been working with for about a year. Now, during most commands I get the message, "Can't execute code in break mode".

How do I turn this off so it doesn't keep prompting me?

I'm not sure you can turn it off. I ususally just step over that line of code to keep it from either stopping the macro if you click 'End' or jumping out of step mode to auto mode if you click continue. There might be a way to disable it, but I have never found it and stepping over the line that sends it to break mode is pretty easy to do.

 

[Leith Ross]

Hello USAMax,

While in the VBIDE (Visual Basic Integrated Development Environment), the system may not always be able to "break" due to processing requirements. You cannot turn this message off like you can in Excel.

 

[USAMax]

Thank you JLGWhiz but I am pressing F8 through my code to see that everything is working. I have been doing this since office 95 and I have never seen this before.

It doesn't happen on any of the logic lines of code such as an IF or DO WHILE, it only happens when the value of a cell is being changed or a different cell is selected.

 

[USAMax]

Leith, this is exactly what I have been looking for. Can you please tell me where to find the setting to turn it off?

My assumption was that it was in Tools, Options and the Editor tab. I tried turning EVERYTHING off but I did not have any luck. Do I have to restart Excel for the changes to take affect?

 

[JLGWhiz]

Thank you JLGWhiz but I am pressing F8 through my code to see that everything is working. I have been doing this since office 95 and I have never seen this before.

It doesn't happen on any of the logic lines of code such as an IF or DO WHILE, it only happens when the value of a cell is being changed or a different cell is selected.

I don't get it very often myself, but if I write the code a certain way, it will crop up. The answer is as @Leith Ross said, it can't be turned off in vba. It is built into the applicaion to protect the app.

 

[USAMax]

Thank you both, but where do I turn it off? Please, it is slowing down my trouble shooting having to press F8 & SPACEBAR, F8 & SPACEBAR, F8 & SPACEBAR, F8 & SPACEBAR. So annoying, please... how do I turn it off?