I'm currently working on some VBA code and I'm getting a strange "can't execute code in break mode" error. The macro runs fine in excel, but the problem arises when I try debugging it with VBA. Any time I step past a line selecting a different sheet or adding a new one this message box appears. I can select OK and the code continues as normal. If I set a break point, it displays a message box for every worksheet change up to that point. The code didn't do this earlier and I'm not sure what would have caused this to start happening. Do you have any suggestions for how I can try to fix it? I'm using Excel 2007 for this project.
Last edited:
