Excel 2010 Bible

Chapter 45: Creating Custom Excel Add-Ins

911

To test it, save the workbook, close it, and then reopen it. With the workbook open, then activate

a different workbook, select some cells that contain text, and then press Alt+F8 to display the

Macros dialog box. Execute the ShowUserForm macro and try all the options.

Adding descriptive information

Adding descriptive information is recommended but not necessary. Choose File ➪ Info ➪

Properties ➪ Show Document Panel to display the Properties panel below the Ribbon. See Figure

45.4. Enter a title for the add-in in the Title field. This text appears in the Add-Ins dialog box. In

the Comments field, enter a description. This information appears at the bottom of the Add-Ins

dialog box when the add-in is selected.

FIGURE 45.4

Use the Document Properties panel to enter descriptive information about your add-in.

Protecting the project

In some situations (such as a commercial product), you may want to protect your project so that

others can’t see the source code. To protect the project, follow these steps:

1. Activate the VB Editor.


2. In the Project window, click the project.


3. Choose Tools ➪ project name Properties. The VB Editor displays its Project Properties
   dialog box.


4. Click the Protection tab (as shown in Figure 45.5).


5. Select the Lock Project for Viewing check box.


6. Enter a password (twice) for the project.


7. Click OK.