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