Use the Add-in from Code
The procedures in this add-in can also be used from Visual Basic code in the test workbook. To use the add-in from code:
From the Visual Basic Editor, choose Tools → References. Visual Basic displays the References dialog.
Select the add-in from the Available References list and click OK.
The add-in won’t appear in the Available References list if it was not loaded from the Add-Ins dialog, as shown in Figure 22-3.
Write code to test the add-in. Press F2 to view the add-in in the Object Browser as shown in Figure 22-5.
Figure 22-5. Using the add-in from code