Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
break points
Hi, anybody have any idea why my breakpoints would stop working. Ive
not knowingly altered anything. Theyve worked fine for a couple of hours, now the code runs over them. They work ok in modules but have stopped working on code I put into the Worksheet_change event. All events are enabled. Regards Robert |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
break points
On Feb 11, 3:48 am, "RobcPettit" wrote:
Hi, anybody have any idea why my breakpoints would stop working. Ive not knowingly altered anything. Theyve worked fine for a couple of hours, now the code runs over them. They work ok in modules but have stopped working on code I put into the Worksheet_change event. All events are enabled. Regards Robert You might still be in design mode on your worksheet. If you are then none of your code is running and that will give the appearance of nonexistant breakpoints. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
break points
Ensure that the "Break In Class Module" option is set. In the VBA editor,
go to the Tools menu, choose Options and in that dialog choose the "General" tab. There, ensure the Error Trapping setting is set to "Break In Class Module". -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "RobcPettit" wrote in message ups.com... Hi, anybody have any idea why my breakpoints would stop working. Ive not knowingly altered anything. Theyve worked fine for a couple of hours, now the code runs over them. They work ok in modules but have stopped working on code I put into the Worksheet_change event. All events are enabled. Regards Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Format numbers from percentage points to basis points | Excel Discussion (Misc queries) | |||
Break even points | Excel Worksheet Functions | |||
How do I find points on a curve between known points? | Excel Worksheet Functions | |||
Break cell into multiple lines by line break | Excel Discussion (Misc queries) | |||
Can Not Get Macro to Break with CTRL-BREAK | Excel Programming |