+ Reply to Thread
Results 1 to 6 of 6

MyAddin not Reacting

Hybrid View

  1. #1
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: MyAddin not Reacting

    All seems to work as expected.
    You have to remove the option explicit because it will not compile otherwise.

    Also the references to libraries need to be added, or you need to change your code to use Late binding and object references.

    But the green arrow on the QAT displays your menu choices and reacts to the click.
    Cheers
    Andy
    www.andypope.info

  2. #2
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    4,056

    Re: MyAddin not Reacting

    Thanks Andy; I didn't even think about the "Option Explicit". That's an easy fix.

    You mention "the references to libraries need to be added", but can I add the references in the "OurAddin.xlam" itself, so my users don't have to (and if so, how?), or is there a way to have the .xlam itself add the references to the user's Excel references?

    You also mentioned "you need to change your code to use Late binding and object references." I've never understood what "late binding" is, so that's a tough one for me. Object references is easy enough.

    Thanks so much for your help thus far. I sure appreciate it.

    Thanks,
    John

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1