How to Remove a Macro in Excel

PDF download Download Article
The complete guide to deleting macros from any Excel workbook
PDF download Download Article

This wikiHow guide teaches you how to remove a macro from a Microsoft Excel spreadsheet. Removing a macro is as simple as opening the macros menu in the "View" tab and deleting the ones you don't want, though you'll have to enable macros in your document before you can do this.

Quick Guide: Removing Macros in Excel

Click the "View" tab, click the "Macros" icon, and then click "View Macros". Select the macro you want to remove and click "Delete".

For popular FAQs on deleting macros in Excel, jump to more common questions .

Method 1
Method 1 of 2:

On Windows

PDF download Download Article
  1. Double-click the Excel file which contains the macro you want to delete. This will open the file in Excel.
  2. 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.
    Advertisement
  3. This tab is in the green ribbon at the top of the Excel window.
  4. It's a drop-down icon
    Android 7 Dropdown
    in the far-right side of the View tab. A drop-down menu will appear.
  5. This option is in the drop-down menu. Doing so opens the Macros pop-up window.
  6. You'll find this at the bottom of the window. Clicking it prompts a drop-down menu.
  7. It's in the drop-down menu.
  8. Click the name of the macro you want to delete.
  9. It's on the right side of the window.
  10. Doing so will remove the macro from your workbook.
  11. Press Ctrl + S to do so. This will ensure that the macro remains deleted after you close Excel.
    12. Advertisement
Method 2
Method 2 of 2:

On Mac

PDF download Download Article
  1. Double-click the Excel file which contains the macro you want to delete. This will open the file in Excel.
  2. 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. It's a menu item at the top of your Mac's screen. Clicking it prompts a drop-down menu.
  4. 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. It's in the pop-out menu. Doing so opens the "Macros" window. [1]
  6. This is near the bottom of the "Macros" window. A drop-down menu will appear.
  7. It's in the drop-down menu.
  8. Click the name of the macro you want to delete.
  9. It's below the list of macros.
  10. This will remove the macro.
  11. Press ⌘ Command + S to do so. This will ensure that the macro remains deleted after you close Excel.
    12. Advertisement

Common Questions: Excel Macros

Can I fully disable macros in Excel?

Go to the File tab and select Options > Trust Center > Trust Center Settings > Macro Settings . In this menu you can choose to disable all macros with notification or without notification. You can also decide to allow macros that are digitally signed, but disable all others.

How do I undo a macro in Excel?

If you run a macro that ends up doing something you want to undo, the only way to get your previous work back is to close the document without saving. If you've saved after you ran the macro, you won't be able to undo the changes due to the way that macros (and VBA code) work.

Why can't I delete an Excel macro?

While in Excel, press Alt + F11 to open the Visual Basic Editor. In the Project Explorer (top-left pane) look for "VBAProject," then look for modules containing macros. If you don't see any macros there, the macros you're using may be controlled by an add-in that can be edited in File > Options > Add-ins .

Tips

  • On a Mac, you can also open the "Macros" window from within the Developer tab by clicking Macros .
    Thanks
    Helpful 0 Not Helpful 0
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Submit
Thanks for submitting a tip for review!
Advertisement

Warnings

  • Macros can harm your computer. Unless you know where a macro came from (e.g., a trusted colleague created it), do not run macros from files you didn't personally create.
    Thanks
    Helpful 0 Not Helpful 0
Advertisement

You Might Also Like

How to
Convert Measurements Easily in Microsoft Excel
How to
Create a Currency Converter With Microsoft Excel
How to
Create a Custom Macro Button in Excel
How to
Create Pivot Tables in Microsoft Excel to Analyze Data
How to
Delete Recent Documents in Microsoft Word or Excel
How to
Merge Cells in Microsoft Excel: A Quick Guide
How to
Unprotect an Excel Sheet
How to
Unhide All Rows and Columns in Microsoft Excel
How to
Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
How to
Insert Pictures in Excel That Automatically Size to Fit Cells
How to
Create a Mortgage Calculator With Microsoft Excel
How to
Create a Graph in Excel
How to
Show Hidden Columns in Microsoft Excel & Unhide Column A
How to
Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
Advertisement

References

  1. ↑ https://support.office.com/en-us/article/create-run-edit-or-delete-a-macro-fc5fb55d-124d-4cc7-bae0-111c9c26e234

About This Article

Article Summary X

1. Open the file.
2. Click Enable Content .
3. Click View .
4. Click the Macros drop-down.
5. Click View Macros and select "This Workbook."
6. Click All Open Workbooks .
7. Select a macro and click Delete .
8. Click Yes .

Did this summary help you?
In other languages
Thanks to all authors for creating a page that has been read 329,115 times.

Is this article up to date?

Advertisement