How to remove all Macros in Excel?

Sometimes you record and create macros in Excel, or receive workbooks with macros. In some cases, you will need to remove all of the macros from workbook. Here we will share two ways to delete all macros in Excel conveniently and quickly.

Remove all macros one by one with Macro command
Easily remove all macros from current workbook with Kutools for Excel
Batch remove all macros from multiple workbooks with Kutools for Excel

Remove all macros one by one with Macro command

Usually we can remove macros one by one with Macro command in Excel.

Step 1: Please click View > Macros > View Macros, see screenshot:

Step 2: Then you get into the Macro dialog box. Select a macro that you want to delete, and choose All open workbooks from drop down list in Macros in area. See screenshot:

Step 3: Click the Delete button, and the selected macro is deleted, and you can redo the Step 2 and Step 3 to remove other macros one by one.

This Macro command can delete only one macro each time. Though it is not required to close the Macro dialog box, we have to delete all macros one by one with the repeating clicking mouse. It will be OK for a few macros, but must be tedious to remove numerous ones with this method.

Remove all macros from current workbook with Kutools for Excel

Kutools for Excel's Remove all Macros makes it possible to remove all macros in the whole workbook at the same time with only one click.

1: Click Kutools > Delete > Remove All Macros, see screenshot:

2. Then a prompt box pops out to tell you all the macros have been removed successfully, click the OK button.

Note: If the Trust access to the VBA project object model option dose not enable in your workbook, a dialog box will display to remind you to enable this option firstly before removing all macros from current workbook.

Batch remove all macros from multiple workbooks with Kutools for Excel

Besides removing all macros in a workbook with Kutools for Excel, you can also batch remove all macros from multiple workbooks at once with the Batch Remove All Macros utility of Kutools for Excel.

1. Click Kutools > Delete > Batch Remove All Macros to enable this utility.

2. In the Remove All Macros dialog box, you can see all opened workbooks are displayed in the dialog box. If you want to remove all macros from other workbooks, please click the Add button, and then click File or Folder option to select the workbooks you need to remove macros from. See screenshot:

Note: You can click the button to remove the unneeded workbook.

3. Now all selected workbooks are displayed in the Remove All Macros dialog box, please click the OK button to start removing. See screenshot:

4. Then a dialog box pops up to tell you how many Macros are removed, click the OK button.

Now all Macros in selected workbooks are removed successfully. And you will get a new workbook with the report of the removing list inside.

Demo: Remove all Macros in Excel with Kutools for Excel

Best Office Productivity Tools

🤖	Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions…
	Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
	Super Lookup: Multiple Criteria VLookup  |   Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
	Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
	Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
	Featured Features: Grid Focus   |  Design View   |   Big Formula Bar   |  Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells   |  Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
	Top 15 Toolsets:  12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Use Kutools in your preferred language – supports English, Spanish, German, French, Chinese, and 40+ others!

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

More details of Kutools for Excel... Free Download...

---

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

• Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
• Open and create multiple documents in new tabs of the same window, rather than in new windows.
• Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!

More details of Office Tab... Free Download...

---

All Kutools add-ins. One installer

Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.

• All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
• One installer, one license — set up in minutes (MSI-ready)
• Works better together — streamlined productivity across Office apps
• 30-day full-featured trial — no registration, no credit card
• Best value — save vs buying individual add-in

More details of Kutools for Office... Free Download...