XL2000: How to Set the Descriptive Name of an Add-in File (214014)

MORE INFORMATION

In Excel, the Add-Ins dialog box lists add-in files that are automatically opened when you start Excel. In the Add-Ins dialog box, these files have descriptive names that resemble the following examples: Add-in files also have descriptive text that appears in the lower part of the dialog box. For example, the descriptive text for the Open Database Connectivity (ODBC) add-in states the following: To set the descriptive name and descriptive text for a workbook that is to be made into an add-in file, follow these steps:

1. With the workbook active, click Properties on the File menu.
2. Click the Summary tab, and then type the following values:

   Title: <intended descriptive name>
   Comments: <intended descriptive text>

3. Click OK to accept the changes.

When you make the workbook into an add-in, the new add-in uses the descriptive name and text that you typed when you added the add-in to the Add-Ins dialog box.

NOTE: If you have already created your add-in file, but you did not properly set the descriptive name and text, it may not be possible to modify the existing add-in file. Instead, you must reopen your source workbook, set the descriptive name and text, and then re-create the add-in.

For additional information about creating an add-in, click the article number below to view the article in the Microsoft Knowledge Base: