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

Creating Custom Excel Functions 743
7. Choose File➪Info.
Excel 2013 displays the Info screen about the workbook in the Backstage view. Here you enter a brief name for the add-in in the Title field and a longer description of its custom functions.
8. Click the Title text box and enter a descriptive title for the add-in, and then click the Save As option on the menu in the Backstage view.
This action opens the Save As screen where the XLSTART folder is currently selected.
9. Click XSTART under Current Folder in the right-hand panel.
Excel opens the Save As dialog box, where you need to change the file type to Excel Add-In (*.xlam) and then specify the filename (to which Excel automatically appends the .xlam filename extension) under which to save it.
10. Click the Save as Type pop-up button and then select Excel Add-In as the type.
11. Click the File Name combo box and make any necessary changes to the filename (without changing the .xlam filename extension) before you click the Save button.
After saving your workbook as an add-in file, you’re ready to activate the add-in so that you can enter its user-defined functions in any worksheet.
12. Choose File➪Options➪Add-Ins or press Alt+FTAA.
13. Click the Go button near the bottom of the Add-Ins tab after checking to make sure that Excel Add-Ins is displayed on the Manage drop-down list button.
This action opens the Add-Ins dialog box showing the names of all the available add-ins. You must now add the name of your new add-in to this list.
14. Click the name of your new add-in file in the Browse list box and then click OK.
This action closes the Browse dialog box and returns you to the Add-Ins dialog box that now lists your new add-in file. Now all you have to do
is make sure that the check box in front of the name of the new add-in (which displays the title and description you gave the add-in at the bottom of the Add-Ins dialog box) is selected before you click OK. (See Figure 2-12.)
15. Select the check box in front of the name of the new add-in and then click OK.
Book VIII Chapter 2
VBA Programming