Macro Question

S

Sandy

Hello group,
I posted this to excel programming NG and have not recieved a useable
response, so I will try here.
I have a macro that emails a copy of a worksheet to a list of recipients
using .SendMail Recipients:=Array. The macro runs fine on some machines and
will not run on others, all have the same OS (XP Pro), MSO 2003 with like
security settings).The unusual part of it is that typically the macro is
fired by a button or a hot key, however, if I run the macro from the editor,
it runs fine. Has any one seen this before that may could tell me what is
wrong?
Thanks
Sandy
 
M

Michael Bauer

Hi Sandy,

do you mean the macro runs manually on every machine, and only the
button doesn´t work?
 
S

Sandy

No. The macro runs manually on all machines and runs via the button only on
some machines, that is the problem not running via the button. Sorry for the
confusion.
 
M

Michael Bauer

Did you setup the button manually? Maybe you just need to re-create
them.
 
S

Sandy

The macro fires and runs by the button up until it gets to the email part.
Thats where is hangs up. If I run it manually it doesnt hang up.
 
Top