How to Batch Delete All Macros from Workbooks in Excel Office 365?
Tags: batchdeleteallmacros, kutoolsexceltutorial, kutools
Published: 2020-11-16 07:28:51

---
title: How to Batch Delete All Macros from Workbooks in Excel Office 365?
published: true
date: 2020-11-15 15:34:16 UTC
tags: BatchDeleteAllMacros,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-batch-delete-all-macros-from-workbooks-in-excel-office-365/
---

In this article, you will understand the steps to **Batch Delete All Macros from Workbooks in Excel Office 365** using **Kutools.** Let’s get into this article!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Batch Remove All Macros:

To remove all macros from your workbook, do as below steps.

- On the **Kutools Tab, select** the **Delete** option, **choose** the **Batch Remove All Macros** option from the menu list.

![Select Batch Remove All Macros option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-9.png)<figcaption id="caption-attachment-16984">Select Batch Remove All Macros option</figcaption>

### Note:

- You need to enable  **Trust access to the VBA project object model option** to get the proper result.
- On the **File tab, click** the **Options** button, and **select** the **Trust Center** option.
- In the **Trust Center Dialog box** , you need to check the **Trust access to the VBA project object model** in this workbook.

![Trust Center Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Trust-Center-Dialog-Box.png)<figcaption id="caption-attachment-16993">Trust Center Dialog Box</figcaption>

- Then, **click** the **OK** button to close this dialog box.

- It will open **Remove All Macros Dialog Box**.
- You can see all **opened workbooks are listed** in the dialog box. If you don’t want to remove macros from any of them, you can use the **remove button** to delete them.
- Then, you need to **click** the **Add** button and **select** the **File** or **Folder** option to add other workbooks.

![Click the Add button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/7-2.png)<figcaption id="caption-attachment-16990">Click the Add button</figcaption>

- Now, it will **open** a **dialog box** where you need to **select the workbooks** you want to remove all macros. Then **click** the **Open** button.

![Select the File](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-8.png)<figcaption id="caption-attachment-16986">Select the File</figcaption>

- After that, all the selected workbooks are listed in the **Remove All Macros dialog box.**
- You need to **click** the **OK** button.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/8-2.png)<figcaption id="caption-attachment-16991">Click the OK button</figcaption>

- Then, a new **prompt box** will pop-out to tell you how many macros have been removed from workbooks and you need to **hit** the **OK** button.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-4.png)<figcaption id="caption-attachment-16988">Prompt box</figcaption>

- Finally, **all macros have been removed** from selected workbooks and a new workbook has been created automatically to show the results.
- Kindly, refer to the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-4.png)<figcaption id="caption-attachment-16989">Result</figcaption>

## Closure:

In the above article, you can clearly understand the steps to **Batch Delete All Macros from Workbooks in Excel Office 365** using **Kutools. ** Don’t forget to share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [How to Create Custom Lists and Fill Cells with them in Excel 365?](https://geekexcel.com/how-to-create-custom-lists-and-fill-cells-with-them-in-excel-365/)
- [Copy Page Setup from One Worksheet to Others in Excel Office 365!!](https://geekexcel.com/copy-page-setup-from-one-worksheet-to-others-in-excel-office-365/)