Macro stopping for one user out of 14
 

I have a workbook that is used by 14 people that contains macros (each have
their own copy of the same workbook). When one of the users clicks on either
of 2 out of the 4 command buttons to run a macro, the macro will run to a
point (always the same line of code) and stop. If the user selects "continue"
the macro will finish. All other users have no error messages or problems. I
even sent a "fresh" copy of the workbook to the user but she experienced the
same problem. The lines of code where the two macros stop are different. One
of the lines of code is: Range("E46").Select, and the other line in the other
macro is: If mySaveName = False Then Exit Sub.

I can not figure out how to correct the problem and have resorted to telling
the user just to select "continue". It is almost as if the problem has to do
with some Excel settings on her PC. By the way, the same macros worked fine
several weeks ago using the same workbook.

Macro stopping for one user out of 14
 

David,

Might be worth a look...check to see if "Break on All Errors" is checked
(in the VBE) under Tools | Options | General (tab). It shouldn't be.
Also, is the 14th person using the same Excel version as the others?

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"David Vollmer"
wrote in message...
I have a workbook that is used by 14 people that contains macros (each have
their own copy of the same workbook). When one of the users clicks on either
of 2 out of the 4 command buttons to run a macro, the macro will run to a
point (always the same line of code) and stop. If the user selects "continue"
the macro will finish. All other users have no error messages or problems. I
even sent a "fresh" copy of the workbook to the user but she experienced the
same problem. The lines of code where the two macros stop are different. One
of the lines of code is: Range("E46").Select, and the other line in the other
macro is: If mySaveName = False Then Exit Sub.

I can not figure out how to correct the problem and have resorted to telling
the user just to select "continue". It is almost as if the problem has to do
with some Excel settings on her PC. By the way, the same macros worked fine
several weeks ago using the same workbook.

Macro stopping for one user out of 14
 

Jim,

Break on All Errors was NOT checked and each person has the same version of
the workbook.

David

"Jim Cone" wrote:

David,

Might be worth a look...check to see if "Break on All Errors" is checked
(in the VBE) under Tools | Options | General (tab). It shouldn't be.
Also, is the 14th person using the same Excel version as the others?

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"David Vollmer"
wrote in message...
I have a workbook that is used by 14 people that contains macros (each have
their own copy of the same workbook). When one of the users clicks on either
of 2 out of the 4 command buttons to run a macro, the macro will run to a
point (always the same line of code) and stop. If the user selects "continue"
the macro will finish. All other users have no error messages or problems. I
even sent a "fresh" copy of the workbook to the user but she experienced the
same problem. The lines of code where the two macros stop are different. One
of the lines of code is: Range("E46").Select, and the other line in the other
macro is: If mySaveName = False Then Exit Sub.

I can not figure out how to correct the problem and have resorted to telling
the user just to select "continue". It is almost as if the problem has to do
with some Excel settings on her PC. By the way, the same macros worked fine
several weeks ago using the same workbook.