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" <(E-Mail Removed)> wrote in message
news:026BA9D4-B966-452D-95A9-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
> news:026BA9D4-B966-452D-95A9-(E-Mail Removed)...
> >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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
>> news:026BA9D4-B966-452D-95A9-(E-Mail Removed)...
>> >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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >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" <(E-Mail Removed)> wrote in message
> >> news:026BA9D4-B966-452D-95A9-(E-Mail Removed)...
> >> >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