Now you can delete your required macros by following steps 1 to 6 of Method 2.This will unhide your Personal Macro Workbook. Select your Personal Macro Workbook from the list of hidden workbooks. Select ‘Unhide’ from the View tab, under the Window group.To unhide and delete macros from your Personal Macro Workbook, follow these steps: In order to delete macros from your Personal Macro Workbook, you need to first unhide them before attempting to delete them. If you have macros in a Personal Macro Workbook, you will find that it is not possible to delete them, since they are hidden by default. What about Hidden Macros in a Personal Macro Workbook? This should display macros in all workbooks that are currently open. Select the dropdown arrow in the field next to ‘ Macros in’. Note: If you don’t see all the macros that you want to delete in the Macros dialog box, they are probably saved in some other workbook. You should find all your selected macros deleted from the list.When asked if you are sure you want to delete your selected macros, click on the Yes.Press the Delete button on the right side of the dialog box.To delete all macros, simply select the first macro, press down the SHIFT key and select the last macro name.
To delete multiple macros, press down the CTRL key and select the macros you want to delete. To delete one macro, just select the macro you want to delete.You can delete one, all, or multiple macros from your workbook. You will see the list of all macros in the list on the left side of the dialog box.
Alternatively, you can click on the Developer tab and select the Macros button (under the Code group).
This method is not suitable if you want to only remove specific macros and keep the rest. The above steps would remove all the macros from the newly saved file.
Method 3: Remove Macros using the Visual Basic Editor.Method 2: Remove Macros using the Macro Dialog Box.Method 1: Remove All Macros by Saving the Workbook in XLSX Format.