How to Remove a Macro in Excel

This updated guide examines How to Remove a Macro in Excel and organizes the essential facts, background, and practical takeaways in clear American English.

Method 1

On Windows

1. Open the macro-enabled Excel sheet. Double-click the Excel file which contains the macro you want to delete. This will open the file in Excel.
2. ClickEnable Content. It's in the yellow bar at the top of the Excel window. This will enable the macro(s) that are embedded in the file.
   • If you don't enable the macro(s), you won't be able to delete your macro.
3. Click theViewtab. This tab is in the green ribbon at the top of the Excel window.
4. ClickMacros. It's a drop-down iconin the far-right side of the View tab. A drop-down menu will appear.
5. ClickView Macros. This option is in the drop-down menu. Doing so opens the Macros pop-up window.
6. Click the "Macros in" drop-down box. You'll find this at the bottom of the window. Clicking it prompts a drop-down menu.
7. ClickAll Open Workbooks. It's in the drop-down menu.
8. Select a macro. Click the name of the macro you want to delete.
9. ClickDelete. It's on the right side of the window.
10. ClickYeswhen prompted. Doing so will remove the macro from your workbook.
11. Save your changes. PressCtrl+Sto do so. This will ensure that the macro remains deleted after you close Excel.

Method 2

On Mac

1. Open the macro-enabled Excel sheet. Double-click the Excel file which contains the macro you want to delete. This will open the file in Excel.
2. ClickEnable Content. It's in the yellow bar at the top of the Excel window. This will enable the macro(s) that are embedded in the file.
   • If you don't enable the macro(s), you won't be able to delete your macro.
3. ClickTools. It's a menu item at the top of your Mac's screen. Clicking it prompts a drop-down menu.
4. SelectMacro. This option is at the bottom of the Tools drop-down menu. Selecting it causes a pop-out menu to the right of the drop-down menu to appear.
5. ClickMacros…. It's in the pop-out menu. Doing so opens the "Macros" window.^[1]
6. Click the "Macros in" drop-down box. This is near the bottom of the "Macros" window. A drop-down menu will appear.
7. ClickAll Open Workbooks. It's in the drop-down menu.
8. Select a macro. Click the name of the macro you want to delete.
9. Click—. It's below the list of macros.
10. ClickYeswhen prompted. This will remove the macro.
11. Save your changes. Press⌘Command+Sto do so. This will ensure that the macro remains deleted after you close Excel.