Page 762 - Excel 2013 All-in-One For Dummies
P. 762
744 Creating Custom Excel Functions
Figure 2-12:
Activating the new add-in file in the Add-Ins dialog box.
As soon as you click OK, Excel closes the Add-Ins dialog box and returns you to the VBA Editor window. You can then select the Save button (Ctrl+S) followed by the View Microsoft Excel button (Alt+F11) on the VBA standard toolbar. When you’re back in the PERSONAL workbook, you can then hide it again by clicking the Hide button on the View tab (Alt+WH)
After that, you can start entering the custom functions that this add-in file contains directly into the cells of any spreadsheet without having to open the Insert Function dialog box.