How to Remove a Macro in Excel

On Windows

1. How to Remove a Macro in Excel Picture 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. How to Remove a Macro in Excel Picture 2
   Click Enable 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.

   1. If you don't enable the macro(s), you won't be able to delete your macro.
3. How to Remove a Macro in Excel Picture 3
   Click the View tab. This tab is in the green ribbon at the top of the Excel window.
4. How to Remove a Macro in Excel Picture 4
   Click Macros. It's a drop-down icon

   How to Remove a Macro in Excel Picture 5

   in the far-right side of the View tab. A drop-down menu will appear.
5. How to Remove a Macro in Excel Picture 6
   Click View Macros. This option is in the drop-down menu. Doing so opens the Macros pop-up window.
6. How to Remove a Macro in Excel Picture 7
   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. How to Remove a Macro in Excel Picture 8
   Click All Open Workbooks. It's in the drop-down menu.
8. How to Remove a Macro in Excel Picture 9
   Select a macro. Click the name of the macro you want to delete.
9. How to Remove a Macro in Excel Picture 10
   Click Delete. It's on the right side of the window.
10. How to Remove a Macro in Excel Picture 11
    Click Yes when prompted. Doing so will remove the macro from your workbook.
11. How to Remove a Macro in Excel Picture 12
    Save your changes. Press Ctrl+S to do so. This will ensure that the macro remains deleted after you close Excel.