ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   My code enters break mode but there are no breakpoints (https://www.excelbanter.com/excel-programming/410698-my-code-enters-break-mode-but-there-no-breakpoints.html)

Mike

My code enters break mode but there are no breakpoints
 
For some odd reason my code is acting like there are breakpoints in a handful
of locations. I tried exporting the module, deleting the old excel file,
creating a new excel file, importing the module, and running it. Same thing
happened. Then I copied the code into Word, deleted the Excel file,
re-created it, and pasted the code into a new module. Same problem.

Any ideas???

I'm using Excel 2007.

Dave Peterson

My code enters break mode but there are no breakpoints
 
I'd try:

Inside the VBE with your workbook's project selected:

Tools|Options|General tab
change the error trapping from "break on all errors" to "break in class module"



Mike wrote:

For some odd reason my code is acting like there are breakpoints in a handful
of locations. I tried exporting the module, deleting the old excel file,
creating a new excel file, importing the module, and running it. Same thing
happened. Then I copied the code into Word, deleted the Excel file,
re-created it, and pasted the code into a new module. Same problem.

Any ideas???

I'm using Excel 2007.


--

Dave Peterson


All times are GMT +1. The time now is 12:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com