Macro Question

[Guest]

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

 

[Michael Bauer]

Hi Sandy,

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

 

[Guest]

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.

 

[Michael Bauer]

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

 

[Guest]

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.

 

[Michael Bauer]

Please show us the code and comment where which error occurs.