Accessing Macro Functions from Microsoft Excel 2010 and Later
Procedure
- Right-click the sheet tab of the active worksheet.
- From the shortcut menu, click Insert.
- Double-click MS Excel 4.0 Macro.
- Click the cell where you want to place the macro function.
- Click Formulas, and then click Insert Function.
- From the category list, select TM1.
- Select the function you want to insert, and then click OK.
- Type values for the arguments.
- Click OK to place the function in the current cell in the macro sheet.