Re: Use event to catch the running of a macro from an add-in

No luck - any other ideas?

Thanks

On May 6, 10:21 am, "Jim Cone" <james.cone...@xxxxxxxxxxxxxx> wrote:
First thing I would try is to see if you can determine the name of the
sub called by the Download menu item... View (menu) | Tools | Customize
and right-click the menu item and see what "assign macro" tells you.

If that works then substitute your own sub for the one assigned to the menu item.
'--
Sub MySubstitue()
On Error GoTo BadChoice
Application.EnableEvents = False
Call MacroAssignedToMenuItem
BadChoice:
Application.EnableEvents = True
End Sub
--

Jim Cone
Portland, Oregon USAhttp://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

<legacy...@xxxxxxxxx>
wrote in message
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

.

Relevant Pages

  • Re: Use event to catch the running of a macro from an add-in
    ... and right-click the menu item and see what "assign macro" tells you. ... Is there a way to determine when a macro from a 3rd-party add-in has ... from the internet and has a custom menu called Custom with a submenu ... If I select download I would like to "catch" that it ...
    (microsoft.public.excel.programming)
  • Accessing Macros defined in Add-In
    ... I am having problems assigning a macro I have created and saved in an ... I have created a macro and have saved the file as a .xla file. ... I then went to Tools - Add-In and selected the file that I had just ... I then choose Tools - Customise and dragged a custom menu item onto the ...
    (microsoft.public.excel.misc)
  • enabling a custom menu at workbook open that is disabled
    ... In an add-in I have created, a custom menu item is created, it is ... In the workbook_open macro of theworkbooks I want the menu to be ... When the workbook opens, I get: ...
    (microsoft.public.excel.programming)
  • 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 ... from the internet and has a custom menu called Custom with a submenu ... If I select download I would like to "catch" that it ...
    (microsoft.public.excel.programming)
  • >>>> MACRO DOWNLOAD <<<<
    ... actool macro download, actool macro download ffxi, adobe macro flash ... download flash macro media, download flash macro media player, ... download for macro media flash, download for macro media flash 6, ...
    (sci.psychology.theory)