Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2007
    Thanked 1 Time in 1 Post

    Macro to invoke a 3rd party add-in's feature? (Excel 2002 )

    I have a number of useful Excel add-ins, some of which involve invoking wizards or other user forms. Some add-ins are password protected and some aren't. Is it possible for me to be able to invoke one of the add-ins macros with my own macro?

    For example: an add-in has a very cool charting wizard, but accessing it requires plowing through many, not always logically organised menus and submenus. I'd like to create a command button to invoke the wizard more quickly.

    I'd appreciate any advice.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Macro to invoke a 3rd party add-in's feature? (Excel 2002 )

    Try setting a reference to the add-in in Tools | References...
    The add-in should be listed below the references that have already been set.
    You can then use the Object Browser (F2) to see which macros and functions are available in the add-in. You may want to contact the developer of the add-in to ask if information about using those macros and functions is available, otherwise you'll have to work it out yourself.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts