can't enter break mode at this time

[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

 

[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.

 

[Guest]

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.

 

[Dave Peterson]

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

 

[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

 

[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!

 

[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

 

[Dave Peterson]

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