Can't access code in break mode

[JenniferMurphy]

I was stepping through some VBA code in break mode when I decided to post a minisheet here. I realize now that I should have exited break mode, but I didn't. I tabedx back to the sheet, selected the range, and tried to execute the minisheet. When I did. I got a pop-up in the macro saying "Can't access code in break mode". I clicked on OK, but it popped up again. I did that 8-10 times or more.

How do I get out of this loop without forcing Excel to close and then having to sort thought the recovered files.

Thanks

 

[Peter_SSs]

Go back to the code that you were stepping though and end that code (Reset)

(or Alt+R+R)

 

[JenniferMurphy]

Go back to the code that you were stepping though and end that code (Reset) View attachment 82192 (or Alt+R+R)

It eventually cleared. I'm not sure what I was doing at the time. I just tried to get it to fail again so I could test your solution, but, of course, now it won't fail.

If it fails again, I'll try what you suggest.

Thanks

 

[Peter_SSs]

Actually, I may have not really addressed your specific situation in trying to use XL2BB while stepping through another code. For me if Excel has recently been opened and I am stepping though a code then click on the xl2bb ribbon tab I do get about a dozen of those messages before it clears (and XL2BB is disabled - presumably since its set-up macros could not run because the 'stepping' code was in operation). That is not particularly an issue with XL2BB as I can get similar situations with other Add-Inns too.

 

[JenniferMurphy]

Actually, I may have not really addressed your specific situation in trying to use XL2BB while stepping through another code. For me if Excel has recently been opened and I am stepping though a code then click on the xl2bb ribbon tab I do get about a dozen of those messages before it clears (and XL2BB is disabled - presumably since its set-up macros could not run because the 'stepping' code was in operation). That is not particularly an issue with XL2BB as I can get similar situations with other Add-Inns too.

That's probably what happened for me. I must have clicked on that pop-up enough times to clear the errors. I'll mark that as a solution, but if that doesn't work, they can try your other suggestion.