Content

• Steps
• Advice
• Warning

In this article, wikiHow teaches you how to delete macros in Microsoft Excel spreadsheets from spreadsheet settings on both Mac and Windows computers.

Steps

Method 1 of 2: On Windows

1. 

   on the far right side of the card View. A drop-down menu will appear.

2. 

   
   
   Click an option View Macros (Show Macros) in the drop-down menu. The Macros window will appear.

3. 

   Click the "Macros in" drop-down box at the bottom of the window. A new drop-down menu will appear.

4. 

   
   
   Click on the option All Open Workbooks (All open workbooks) in the drop-down menu.

5. 

   Select any macro. Click the name of the macro you want to delete.

6. 

   
   
   Press the button Delete (Delete) on the right side of the window.

7. 

   Press Yes (Agree) when asked to remove macros from your workbook.

8. 

   Save changes by pressing Ctrl+S. This step ensures the macro is completely deleted even after you close Excel. advertisement

Method 2 of 2: On a Mac

1. 

   Open the Excel page with macro enabled. Double-click the Excel file that contains the macro you want to delete to open it in Excel.

2. 

   Press Enable Content on the yellow bar at the top of the Excel window. Macros embedded in the file will be activated.
   • You cannot delete it without enabling macros.

3. 

   Click the menu Tools (Tools) at the top of the Mac screen. A drop-down menu will appear.

4. 

   Choose Macro at the bottom of the menu Tools. A new menu will open on the right side of the original menu.

5. 

   Click Macros ... in the newly opened menu to open the "Macros" window.

6. 

   Click the "Macros in" drop-down box near the bottom of the "Macros" window. A new drop-down menu will appear.

7. 

   
   
   Press All Open Workbooks in the drop-down menu.

8. 

   Select any macro. Click the name of the macro you want to delete.

9. 

   
   
   Press the button — below the list of macros.

10. 

    Press Yes when asked to delete the selected maro.

11. 

    
    
    Save your changes with the key combination ⌘ Command+S. Macros will be deleted completely. advertisement

Advice

• On a Mac, you can also open the "Macros" window from the tab Developer (Developer) by clicking Macros.

Warning

• Macros can damage your computer. Unless you know the origin (such as one generated by a trusted colleague), don't run macros from a file you didn't create yourself.