Removing a macro from the personal macroworkbook in Microsoft Excel 2019

When storing macros in the personal macro workbook, you need tounhide the workbook in order to remove a macro:

1. Go to View | Unhide from the Window group.
2. In the Unhide dialog box, makesure that the PERSONAL.XLSB workbook is selected, then clickon OK. The personal macro workbookwill open:

3. To remove the macro, click on Developer |Macros:

4. Make sure PrintSettings isselected, then press the Deletebutton.
5. You will be asked to confirm the deletion of the macro via aninformation dialog box. Click OK toconfirm.
6. Close the workbook and click on Yes if prompted to save.

In this section, you learned about consolidating data, as well ascreating macros to perform workbook tasks. In the next section, we willlearn how to work with PivotTables and PivotCharts to reorganize andsummarize data.