Skip to main content

How to remove all Macros in Excel?

Author: Kelly Last Modified: 2020-05-21

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:

doc-remove-macro1

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:

doc-remove-macro2

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.

Before applying Kutools for Excel, please download and install it firstly.

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.

doc delete macros1

  If you want to have a free trial (30-day) of this utility, please click to download it, and then go to apply the operation according above steps.


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.

  If you want to have a free trial (30-day) of this utility, please click to download it, and then go to apply the operation according above steps.


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 Toolsets12 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

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...

Description


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!
Comments (2)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Hallo,

1) witch ExtendeOffice product is compatible with Office 2003 ?

2) have you edu discount for student and teacher ?

3) witch product work in Italian language ?

Tanks' for answering and a nice 2014!

gianni_ghidossi@swissonline.ch
This comment was minimized by the moderator on the site
Hallo,

1) witch ExtendeOffice product is compatible with Office 2003 ?

2) have you edu discount for student and teacher ?

3) witch product work in Italian language ?

Tanks' for answering and a nice 2014!

gianni_ghidossi@swissonline.ch
By Gianni Ghidossi

Hello, Kutools for Excel is not compatible with Office 2003. For edu discount for student and teacher, please send an email at sales@extendoffice.com.

:-)
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations