Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to add a description to an Excel AddIn

Tags:

excel

vba

How do I add a description to an Excel AddIn like in the picture below:

Excel AddIn Manager

You can see the Euro Tools AddIn has one.

like image 322
noobmaster69 Avatar asked Jun 13 '17 14:06

noobmaster69


People also ask

How do you modify Excel add-ins?

Click the File tab, click Options, and then click the Add-Ins category. In the Manage box, click COM Add-ins, and then click Go. The COM Add-Ins dialog box appears. In the Add-Ins available box, clear the check box next to the add-in that you want to remove, and then click OK.

How do I add a description to a macro in Excel?

When you record a macro code using the macro recorder, you get an option to add a description before you record it. So when you open the record macro dialog box, there is a “Description” input box where you can add your comment and then start recording.

How do you reference an Excel add-in?

Add A Reference Make sure that you click on the workbook you want to add the reference to, and from the VBA editor menu choose Tools -> References. In the displayed list check the box beside your renamed add-in, and then click on OK. You'll see that your workbook now has a new reference to the add-in.


1 Answers

Like so:

File, Info, Properties, Advanced properties. Click the Summary tab. The Title is what shows up as the name of your add-in. The Comments section shows up as description.

like image 56
jkpieterse Avatar answered Oct 12 '22 09:10

jkpieterse