Debugging why a macro does not fire

By Peter N Lewis on Monday, May 10, 2010

With great power comes great responsibility, or in this case, some complexity. And when that great power doesn’t work quite right, it pays to know what to do to get it working again.

If a macro does not execute when you try the trigger, there are a number of possibilities to check:

• Check that the macro group is enabled and is active in the desired application.
• Check that the macro is enabled.
• Check that the trigger is as expected.
• Check that the actions look correct and are enabled.

If you cannot spot a problem, and the macro still wont fire, then you need to narrow down where the problem might lie.

Add a Status Menu trigger to the macro and see if the macro appears in the status menu - if not, then the macro or macro group is disabled or inactive.

If it does appear, then try executing the macro using the Status Menu. If it works, then you're down to just the trigger. If not, it may be that the actions are not doing what you think they should.

And if you still cannot figure it out, email me and let me know what you have learned from trying the above so I can help you narrow down where the problem might be.

Posted Monday, May 10, 2010. Permalink. Post a Comment.