Accessing Macro Functions from Microsoft Excel 2010 and Later

Procedure

  1. Right-click the sheet tab of the active worksheet.
  2. From the shortcut menu, click Insert.
  3. Double-click MS Excel 4.0 Macro.
  4. Click the cell where you want to place the macro function.
  5. Click Formulas, and then click Insert Function.
  6. From the category list, select TM1.
  7. Select the function you want to insert, and then click OK.
  8. Type values for the arguments.
  9. Click OK to place the function in the current cell in the macro sheet.