This article explains how to delete a macro from a Microsoft Excel sheet. You can do this by tweaking the spreadsheet configuration settings on both Windows and Mac platforms.
Steps
Method 1 of 2: Windows
Step 1. Open the Excel file where the macro is present
Double-click the Excel file icon that contains the macro you want to delete. The document will appear inside the Excel window.
Step 2. Click the Enable Content button
It is displayed inside the yellow bar that appeared at the top of the Excel window. This will enable the execution of the macros in the file you have opened.
If you don't enable macros to run, you won't be able to delete those in the open document
Step 3. Click on the View tab
It is one of the Excel ribbon tabs located at the top of the program window.
Step 4. Click on the Macro button
It is characterized by the following icon
and is located on the right side of the card View. A drop-down menu will appear.
Step 5. Click on the View Macro item
It is one of the options present in the drop-down menu that appeared. The "Macro" dialog will be displayed.
Step 6. Click on the "Store macro in" drop-down menu
It is located at the bottom of the window that appeared. A list of options will be displayed.
Step 7. Click on the All Open Workbooks item
It is one of the options present in the drop-down menu that appeared.
Step 8. Select a macro
Click on the name of the macro you want to delete.
Step 9. Click the Delete button
It is displayed on the right side of the "Macro" window.
Step 10. Click the Yes button when prompted
The selected macro will be deleted from the workbook.
Step 11. Save your changes
Press the key combination Ctrl + S. This way you can be sure that the macro will not be restored when you close the Excel window.
Method 2 of 2: Mac
Step 1. Open the Excel file where the macro is present
Double-click the Excel file icon that contains the macro you want to delete. The document will appear inside the Excel window.
Step 2. Click the Enable Content button
It is displayed inside the yellow bar that appeared at the top of the Excel window. This will enable the execution of the macros in the file you have opened.
If you don't enable macros to run, you won't be able to delete those in the open document
Step 3. Click on the Tools menu
It is displayed at the top of the Mac screen. A drop-down menu will appear.
Step 4. Select the Macro option
It's located at the bottom of the drop-down menu Tools. This will bring up a submenu to the right of the main one.
Step 5. Click on the Macros… option
It is one of the items in the sub menu that appeared. The "Macro" dialog will be displayed.
Step 6. Click on the "Store macro in" drop-down menu
It is located at the bottom of the window that appeared. A list of options will be displayed.
Step 7. Click on the All Open Workbooks item
It is one of the options present in the drop-down menu that appeared.
Step 8. Select a macro
Click on the name of the macro you want to delete.
Step 9. Click the - button
It is located at the bottom of the list of available macros.
Step 10. Click the Yes button when prompted
The selected macro will be deleted from the workbook.
Step 11. Save your changes
Press the key combination ⌘ Command + S. This way you can be sure that the macro will not be restored when you close the Excel window.
