How do I bypass the "Can't enter break mode at this time" error. I am trying
to find the source of the problem in my code but when this message comes up I
on't have the option to Debug. I only have options to Continue, End and Help.
How do I get in the Debug mode to try and fix my code problem?
Thanks

There are certain instructions in VBA that will produce this warning message.
You can't eliminate this message. You either have to put break points
futher in the code past these instructions. If you are stepping through the
code you have to add a break point futher in the code and then press F5 to go
to break point. What also helps is adding debug.print statments to see what
is happening in the areas that you can't sterp through your code.

"Ayo" wrote:

How do I bypass the "Can't enter break mode at this time" error. I am trying
to find the source of the problem in my code but when this message comes up I
on't have the option to Debug. I only have options to Continue, End and Help.
How do I get in the Debug mode to try and fix my code problem?
Thanks

The problem is, no matter where I put the break point, I get the error
message. It is not allowing me to debug my code.

"Joel" wrote:

There are certain instructions in VBA that will produce this warning message.
You can't eliminate this message. You either have to put break points
futher in the code past these instructions. If you are stepping through the
code you have to add a break point futher in the code and then press F5 to go
to break point. What also helps is adding debug.print statments to see what
is happening in the areas that you can't sterp through your code.

"Ayo" wrote:

How do I bypass the "Can't enter break mode at this time" error. I am trying
to find the source of the problem in my code but when this message comes up I
on't have the option to Debug. I only have options to Continue, End and Help.
How do I get in the Debug mode to try and fix my code problem?
Thanks

I usually end up adding msgboxes to the code as a last resort when it doesn't
let me use beak points. Sometimes I comment out the instruction that is
preventing the break point. then add it back in after the rest of the code
is working.

"Ayo" wrote:

The problem is, no matter where I put the break point, I get the error
message. It is not allowing me to debug my code.

"Joel" wrote:

There are certain instructions in VBA that will produce this warning message.
You can't eliminate this message. You either have to put break points
futher in the code past these instructions. If you are stepping through the
code you have to add a break point futher in the code and then press F5 to go
to break point. What also helps is adding debug.print statments to see what
is happening in the areas that you can't sterp through your code.

"Ayo" wrote:

How do I bypass the "Can't enter break mode at this time" error. I am trying
to find the source of the problem in my code but when this message comes up I
on't have the option to Debug. I only have options to Continue, End and Help.
How do I get in the Debug mode to try and fix my code problem?
Thanks

Thanks Joel. I think I have found a way around my problem. The offending code
lines a
Worksheets("FC Construction").Delete
Windows("FC CONSTRUCTION TRACKER_V2.xls").Activate
Sheets("FC Construction").Select
Sheets("FC Construction").Copy
After:=Workbooks("DailyStatus.xls").Sheets("Dates" )
So I commented out the first line and now I am able to debug the codes.

"Joel" wrote:

I usually end up adding msgboxes to the code as a last resort when it doesn't
let me use beak points. Sometimes I comment out the instruction that is
preventing the break point. then add it back in after the rest of the code
is working.

"Ayo" wrote:

The problem is, no matter where I put the break point, I get the error
message. It is not allowing me to debug my code.

"Joel" wrote:

There are certain instructions in VBA that will produce this warning message.
You can't eliminate this message. You either have to put break points
futher in the code past these instructions. If you are stepping through the
code you have to add a break point futher in the code and then press F5 to go
to break point. What also helps is adding debug.print statments to see what
is happening in the areas that you can't sterp through your code.

"Ayo" wrote:

How do I bypass the "Can't enter break mode at this time" error. I am trying
to find the source of the problem in my code but when this message comes up I
on't have the option to Debug. I only have options to Continue, End and Help.
How do I get in the Debug mode to try and fix my code problem?
Thanks