My code enters break mode but there are no breakpoints

M

Mike

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.
 
D

Dave Peterson

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"
 

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.

Ask a Question

Top