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

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.

DanR wrote:

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

"DanR" wrote:

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

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

JLGWhiz wrote:

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.

"DanR" wrote:

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

"JLGWhiz" wrote in message
...
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.

"DanR" wrote:

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

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 wrote:

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

"JLGWhiz" wrote in message
...
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.

"DanR" wrote:

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 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" wrote in message
...
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 wrote:

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

"JLGWhiz" wrote in message
...
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.

"DanR" wrote:

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

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

DanR wrote:

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" wrote in message
...
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 wrote:

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

"JLGWhiz" wrote in message
...
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.

"DanR" wrote:

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

--

Dave Peterson