How to Remove a Macro in Excel

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. 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. Click Tools. It's a menu item at the top of your Mac's screen. Clicking it prompts a drop-down menu.

4. Select Macro. 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. Click Macros…. 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. Click All 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. Click Yes when prompted. This will remove the macro.

11. Save your changes. Press ⌘ Command+S to do so. This will ensure that the macro remains deleted after you close Excel.