View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] legacyvbc@gmail.com is offline
external usenet poster
 
Posts: 7
Default Use event to catch the running of a macro from an add-in

Is there a way to determine when a macro from a 3rd-party add-in has
started running and when it has finished?

For example, lets say I have a 3rd party add-in that downloads data
from the internet and has a custom menu called Custom with a submenu
called Download. If I select download I would like to "catch" that it
was called and set application.enableevents to false and then whenever
it is done I would like to turn it back on.

Is this possible?
Thanks