mysteriously enters into break mode

[Ben]

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

 

[joel]

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

 

[RB Smissaert]

Just a guess, but in the VBE look under Tools, Options, General, Error
trapping:
Do you have Break on Unhandled Errors and does that other user have Break on
All Errors?
That possibly could explain it.

RBS

 

[Ben]

Joel,

I will check the user's vbe setting. But the code has no errors though.
Thanks again.

Ben

 

[Ben]

RB,

I will check the user setting. It's strange because the runs on every
one else's machine without entering into break mode and there's no error.

Thanks again,

Ben

 

[jgeiselman]

I have experienced the same problem from time to time with different users running different macros (frequently though). I would agree with Ben that it is probably not the macro's fault. When I ask the user when the last time that have actually rebooted the PC, it has been a number of weeks. The problem normally goes away after they reboot and then reboot periodically (like weekly). It seems to be an accumulation use bug. Recently I have one user in which the reboot did not solve this, so I'm interested in any other ideas.