macro compiles but does not work it seems

[buddha88]

hi!
i have extra macro! when i open the macro and click run , it runs. but actually it does not run the stop button and run button both seesm to be on.
how i can avoid not running the macro.
is there any idea. other than reboot the system.

 

[sagitt]

Hi Buddha,

I got the same issue. I had all variables declared explicitly wits keyword "Global", and it seems to me that Extra did not like it. After i changed "global" to "Dim" everything was running smoothly.

So point I have learnt out of that was:

1. avoid global declarations for variables,
2. keep variables as local as possible,

since then I have not issue with macro running and not running

hope this help,

regards, Dom