File - Add to Workbook - New Workbook

Ribbon bar. Select the Home tab. In the Output group, click Add to Workbook and from the menu, select Add to New Workbook to create a new workbook and add the current macro to it.

Classic menus. From the File - Add to Workbook submenu, select New Workbook to create a new workbook and add the current macro to it.

Note: in addition to adding the current macro to a new workbook, you can select any currently open workbook from the list provided in the File - Add to Workbook menu. If there are not any workbooks open at this time, the menu contains only two options: Add to Analysis Workbook (which may be dimmed) and New Workbook.