Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    How do I access a .xla sub? (Excel All)

    Hi,

    I created a macro sub procedure and saved it as a .xla add-in. Most of the add-ins I have created in the past are function procedures. These are easy to activate and use as one collects them from the Insert Function dialog under User Defined. My question is, if one creates a sub procedure and save it as an add-in, then activate it in the Tools | Add-ins, how does one see it or use it an a random workbook? It does not list in the Macro | Macros dialog!

    TX
    Regards,
    Rudi

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: How do I access a .xla sub? (Excel All)

    Typically the addin will or should create a toolbar item to run it.

    MS MVP Jan Karel <!profile=Pieterse>Pieterse<!/profile> has an excellent article on creating Toolbars for addins.

    Steve

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: How do I access a .xla sub? (Excel All)

    Steve's answer is the best solution but, just for info, you can run the macro if you know its name by typing it into the macro dialog and pressing Run.
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: How do I access a .xla sub? (Excel All)

    TX to both of you!
    Regards,
    Rudi

Posting Permissions

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