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

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

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" wrote in message
...
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,

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

Ben


On 5/8/2009 3:41 PM, joel wrote:
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

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


On 5/8/2009 3:43 PM, RB Smissaert wrote:
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" wrote in message
...
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