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
![Remove a Macro in Excel Step 1 Remove a Macro in Excel Step 1](https://i.sundulerparents.com/images/003/image-7428-1-j.webp)
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.
![Remove a Macro in Excel Step 2 Remove a Macro in Excel Step 2](https://i.sundulerparents.com/images/003/image-7428-2-j.webp)
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
![Remove a Macro in Excel Step 3 Remove a Macro in Excel Step 3](https://i.sundulerparents.com/images/003/image-7428-3-j.webp)
Step 3. Click on the View tab
It is one of the Excel ribbon tabs located at the top of the program window.
![Remove a Macro in Excel Step 4 Remove a Macro in Excel Step 4](https://i.sundulerparents.com/images/003/image-7428-4-j.webp)
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.
![Remove a Macro in Excel Step 5 Remove a Macro in Excel Step 5](https://i.sundulerparents.com/images/003/image-7428-6-j.webp)
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.
![Remove a Macro in Excel Step 6 Remove a Macro in Excel Step 6](https://i.sundulerparents.com/images/003/image-7428-7-j.webp)
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.
![Remove a Macro in Excel Step 7 Remove a Macro in Excel Step 7](https://i.sundulerparents.com/images/003/image-7428-8-j.webp)
Step 7. Click on the All Open Workbooks item
It is one of the options present in the drop-down menu that appeared.
![Remove a Macro in Excel Step 8 Remove a Macro in Excel Step 8](https://i.sundulerparents.com/images/003/image-7428-9-j.webp)
Step 8. Select a macro
Click on the name of the macro you want to delete.
![Remove a Macro in Excel Step 9 Remove a Macro in Excel Step 9](https://i.sundulerparents.com/images/003/image-7428-10-j.webp)
Step 9. Click the Delete button
It is displayed on the right side of the "Macro" window.
![Remove a Macro in Excel Step 10 Remove a Macro in Excel Step 10](https://i.sundulerparents.com/images/003/image-7428-11-j.webp)
Step 10. Click the Yes button when prompted
The selected macro will be deleted from the workbook.
![Remove a Macro in Excel Step 11 Remove a Macro in Excel Step 11](https://i.sundulerparents.com/images/003/image-7428-12-j.webp)
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
![Remove a Macro in Excel Step 12 Remove a Macro in Excel Step 12](https://i.sundulerparents.com/images/003/image-7428-13-j.webp)
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.
![Remove a Macro in Excel Step 13 Remove a Macro in Excel Step 13](https://i.sundulerparents.com/images/003/image-7428-14-j.webp)
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
![Remove a Macro in Excel Step 14 Remove a Macro in Excel Step 14](https://i.sundulerparents.com/images/003/image-7428-15-j.webp)
Step 3. Click on the Tools menu
It is displayed at the top of the Mac screen. A drop-down menu will appear.
![Remove a Macro in Excel Step 15 Remove a Macro in Excel Step 15](https://i.sundulerparents.com/images/003/image-7428-16-j.webp)
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.
![Remove a Macro in Excel Step 16 Remove a Macro in Excel Step 16](https://i.sundulerparents.com/images/003/image-7428-17-j.webp)
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.
![Remove a Macro in Excel Step 17 Remove a Macro in Excel Step 17](https://i.sundulerparents.com/images/003/image-7428-18-j.webp)
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.
![Remove a Macro in Excel Step 18 Remove a Macro in Excel Step 18](https://i.sundulerparents.com/images/003/image-7428-19-j.webp)
Step 7. Click on the All Open Workbooks item
It is one of the options present in the drop-down menu that appeared.
![Remove a Macro in Excel Step 19 Remove a Macro in Excel Step 19](https://i.sundulerparents.com/images/003/image-7428-20-j.webp)
Step 8. Select a macro
Click on the name of the macro you want to delete.
![Remove a Macro in Excel Step 20 Remove a Macro in Excel Step 20](https://i.sundulerparents.com/images/003/image-7428-21-j.webp)
Step 9. Click the - button
It is located at the bottom of the list of available macros.
![Remove a Macro in Excel Step 21 Remove a Macro in Excel Step 21](https://i.sundulerparents.com/images/003/image-7428-22-j.webp)
Step 10. Click the Yes button when prompted
The selected macro will be deleted from the workbook.
![Remove a Macro in Excel Step 22 Remove a Macro in Excel Step 22](https://i.sundulerparents.com/images/003/image-7428-23-j.webp)
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.