Excel Add-in but it won't display under the Add-in tabs

[Ollie1980]

I created an Excel Add-in but it won't display under the Add-in tabs. I tried with Excel 2013 and Excel 2016. The add-in is saved in the Microsoft folder for addins (AppData>Roaming, etc.)Things I've tried....Excel Options > Add-ins > Excel Add-Ins > Go .... Select it.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-insAfter each of these steps, I've closed Excel and reopened it. 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. Thank you! Very frustrating.

 

[offthelip]

Try the Trust Center/ Addins and make sure that "Require Application Addins to be signed by Trusted Publisher" is unticked

 

[Ollie1980]

Try the Trust Center/ Addins and make sure that "Require Application Addins to be signed by Trusted Publisher" is unticked

Darn. That didn't work either. Thank you for the tip though.

 

[Jon Peltier]

Does the add-in have any toolbar buttons that might appear in the Add-Ins tab? There has to be something for the Add-Ins tab to display.

Or maybe you should consider building a custom ribbon tab.

 

[Ollie1980]

Does the add-in have any toolbar buttons that might appear in the Add-Ins tab? There has to be something for the Add-Ins tab to display.

Or maybe you should consider building a custom ribbon tab.

Thank you, John!! I didn't know that I needed to do this. Thank you for pointing me in the right direction.

This is the website I found to help.

http://access-excel.tips/create-excel-add-in-and-add-in-ribbon/

 

[Jon Peltier]

Good job. Post any questions about the ribbon in this forum, but start a new thread.