Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

macro compiles but does not work it seems

Status
Not open for further replies.

buddha88

Programmer
Sep 9, 2009
13
CA
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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top