View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
John Bundy John Bundy is offline
external usenet poster
 
Posts: 772
Default "Can't enter break mode at this time" error coming up

Not really an official way, but I will often have a msgbox pop up, this will
break the code until you click ok, you can place anywhere and still go into
your code and look at data, iterations etc, instead of pressing "play" again
you just hit ok and it goes to the next break or msgbox
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"robs3131" wrote:

Wow - I should've searched this site first before going to Google! Don't
know why I forgot to do that. Anyway, I saw a thread from back in May of
this year about this exact issue - it seems that no one had a way of working
around the issue. If anyone does have a way to workaround this, please let
me know.

Thanks!

--
Robert


"robs3131" wrote:

Hi,

After spending some time rearching this on Google, I was able to find that
the issue is that I am adding ActiveX controls in my code -- apparently, when
this is done, you can't put breaks in the code. I commented out where I am
adding the Active X controls and I was indeed able to put the break in my
code.

I'm wondering - does anyone know if there is a workaround to this issue?
I'd like to think that there is a way to have ActiveX controls added through
my code and still be able to put a break in my code.

Thanks!

--
Robert


"robs3131" wrote:

Hi,

I am trying to have my code execute up to a point and then stop -- I have
been doing this successfully, up until now, by typing "Stop" into my code
where I want the code execution to suspend. For some reason, I am now
getting the error message noted in the subject of this post -- when I click
on "Help", it gives me the following explanation (below is the only wording
from this explanation that appears that it applies to my case). When I
queried info on "extensibility", I was brought to the help for Security - I
tried changing the "Trust all installed add-ins and templates" checkbox but
that didn't fix the issue.

"A change was made programmatically to the project using the extensibility
(add-in) object model. This prevents the program from having execution
suspended. You can continue running, or end execution, but can't suspend
execution."

Thanks in advance!
--
Robert