Chapter 48: Creating Custom Excel Add-Ins
48
- Choose File ➪ Options ➪ Add-Ins.
- Select Excel Add-Ins from the Manage drop-down list and then click Go. The
Add-Ins dialog box appears. - Click the Browse button to locate the XLAM file that you created, which installs
the add-in. The Add-Ins dialog box uses the descriptive title that you provided for
the Title field in the Show All Properties panel.
You can continue to modify the macros and UserForms in the XLAM version of your file. Because the add-in doesn’t
appear in the Excel window, you save your changes in the VB Editor by choosing File ➪ Save.Looking at an Add-In Example
This section discusses the steps required to create a useful add-in from the
change case.xlsm workbook that we covered in Chapter 44, “Creating UserForms.” This
workbook contains a UserForm that displays options that change the text case of selected
cells (uppercase, lowercase, or proper case). Figure 48.2 shows the add-in in action.FIGURE 48.2
This dialog box enables the user to change the case of text in the selected cells.