can't enter break mode at this time

D

DanR

When trying to stop at a breakpoint, "can't enter break mode at this time"
is displayed.
How do I get around this?

Excel 2003,
Dan
 
D

Dave Peterson

I set a break point on the previous line and another on the subsequent line.

Then I don't step through it. I run to the next break point.
 
J

JLGWhiz

I was getting that when I was editing some code by stepping through. When I
executed a step that deleted a WordArt shape, it gave me the "Can't enter
breakpoint" message. However, when I ran the code in full, it did not
display the message. I never figured it out, but so far it has only done it
with the WordArt shape, so I just ignored the one I got during the edit
process.
 
D

Dave Peterson

I get the same error when I'm stepping through code that adds controls (to a
worksheet) from the Control toolbox toolbar.
 
D

DanR

I have tried setting breakpoints at various places but does not help. Code
is started via UserForm (tried modal & modeless). This used to step but I
can't figure out what changed or ?. Code is now password protected operating
after opened by password. Could the protection be getting in the way?

Dan
 
D

Dave Peterson

I think it depends on how you start your code. If I click in the subroutine
that shows the userform and hit F8 to step through it, then I continue to step
through the code.

But you may want to add a line:
Stop
to stop where you want.

Remove that line before you give the workbook to others!
 
D

DanR

I took a clue from WordArt comment. Turns out that this happens 'after' a
listbox is inserted on a sheet. It seems that if I inhibit the listbox, I
can step the code.

Dan
 
D

Dave Peterson

If that listbox is from the control toolbox toolbar, then it's pretty common in
my experience.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top