Search code examples
exceladd-invba

Excel Add-In Not Showing in Ribbon


I created an Excel Add-in but it won't display under the Add-in tabs. Things I've tried....

  • Excel Options > Add-ins > Excel Add-Ins > Go .... Select the add-in.
  • Excel Options > Add-ins > Disabled Items > Go ... I made sure it wasn't disabled.
  • Right click the XLAM file > Properties > General Tab > Select Unblock....(This actually wasn't even an option for me. The UNBLOCK check box did not appear on the window).
  • Excel Options > Trust Center > Trust Center Settings > Trusted Locations > Add the directory where I store my add-ins
  • Excel Options > Trust Center> Addins ..... I made sure that "Require Application Addins to be signed by Trusted Publisher" was unticked

Also, this is my first ADD-IN, so if there is some code I'm supposed to include in my script, please let me know. I thought just saving it as an XLAM file would do the trick.


Solution

  • I found out that I need to tell Excel to create a link in the ribbon upon opening the Excel application.

    This thread answers my question. Sorry for the dupe.

    Write Excel Addin with VBA and then Put a button that trigger it