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.
Copyright © 2021. Cloud Software Group, Inc. All Rights Reserved.