When stepping through code using F8, macro automatically runs at Workbooks.Open line

On my work computer (Excel 2010, Win 7) when I am stepping through my VBA code using F8 and come to a Workbooks.Open line, the macro automatically kicks in and runs through to the end instead of just stepping to the next line of code. This happens nearly every time but occasionally it works as it should. To prevent this, I have to put a breakpoint on the next line following Workbooks.Open and after that I can step (F8) through the rest of the code. I have never had this problem before and it doesn't happen on my home computer. Any ideas?

Thanks MarvinP. I read the MS article, though I don't fully understand all the technical parts. I tried your suggestion and it's definitely going to save me from a lot of frustraion. But I am now wondering why this would suddenly begin happening to my code? I have been writing VBA for years and don't remember having this issue. Does it have anything to do with Windows 7. I don't recall if this started happening immediately after I got a new work laptop with Windows 7 back in November but I don't have the problem on my WinXP computer at home.

Follow up on my original post: I added DoEvents before and after my Workbook.Open line as suggested and it seemed to solve my problem. When I stepped through the Workbook.Open line, it stepped to the next line of code. However, today, I am working with another workbook with same issue. I added DoEvents before and after the Workbook.Open line as you suggested and, once again, as I step (pressing F8 in the VBE) through the Workbook.Open line, the macro runs to the end as if I had pressed F5. Is there something else going on here?

Please Login or Register  to view this content.