Set Add-in Properties
The document properties of the source workbook determine the title and description displayed in the Add-Ins dialog. To set the properties of an add-in:
Open the source workbook for the add-in.
Choose File → Properties. Excel displays the document Properties dialog box (Figure 22-7).
Set the properties and click OK.
Save the source workbook, then save the file again as an .xla file.
The Title property appears in the Add-Ins dialog in the list of available add-ins. The Comments property appears as the description at the bottom of the dialog when the add-in is selected. The other document properties are not displayed, but are available through the AddIn object.

Figure 22-7. Setting add-in document properties
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access