Page 760 - Excel 2013 All-in-One For Dummies

742 Creating Custom Excel Functions
3. Choose Tools➪VBAProject Properties from the Visual Basic Editor’s
menu bar.
This action opens the VBAProject — Project Properties dialog box with a General and a Protection tab, shown in Figure 2-11.
Figure 2-11:
Protecting the VBA project so that its user- defined functions can’t be changed.
4. Click the Protection tab and then select the Lock Project for Viewing check box.
Putting a check mark in this check box prevents other users from view- ing the custom functions so that they can’t make any changes to them. Next, you add a password that prevents them from removing the view protection status.
5. Click the Password text box, enter the password there, and then click the Confirm Password text box and re-enter the password exactly as you entered it in the text box above before you click OK.
Now you’re ready to return to the worksheet where you need to add a title and description for the new add-in file.
6. Click the View Microsoft Excel button at the beginning of the Standard toolbar.
This action returns you to the worksheet in Excel. Before saving the workbook as an add-in, you should add a title for the user-defined func- tions that it contains. (This information then appears in the Add-Ins dialog box whenever you select the add-in file.)