Check the break on error option
VBA menu - tools - options - General

"Ben" wrote:

Hi all,

I am not sure why, but I have a piece of code that runs fine in all the
users except one. when he runs the code, for some strange reason, the
macro keeps entering into break mode on his PC. But no one else's. The
help said that's because an escape keep is pressed or ctrl break was
press.

I selected clear break point in the vba environment and save the xls
file into Excel 2003 format. We even changed a keyboard for him and it
still enters break mode. Once it enters break mode, I pressed F5, it
would run a few lines of code and enter into break mode again.

I have seen this problem before. I actually seen it in my Access 2003
apps as well. After I pressed F9 it enters the break mode. But once I
clear the break point in my Access app, I re-ran it and it would still
do the same.

Any idea what it would be?

Thanks so much for sharing your thoughts.

Ben