Quickly remove all Macros within worksheet or workbook in Excel 2007/2010
To remove all macros in Excel, you have to delete all of them separately. If you have the Remove All Macros utility of Kutools for Excel, you can remove all macros in a time with one or two clicks.
1. Click "Kutools">> Utilities>>Remove All Macros…See screenshot (Fig.1)
Fig. 1 Remove All Macros
2. The pop-up dialog box will display a list of macro-related items found in the active workbook. Select the items to remove and click OK. See screenshot (Fig.2)
Fig. 2 The dialog box of Remove All Macros
3. A message will appear that displays a summary of the results. See screenshot (Fig.3)
Fig. 3 The message after removing all macros
Tip: Remove All Macros can help you delete all the following elements.
| Item | Description |
| VBA Macros | All VBA macros in the workbook, including those found in VBA modules, class modules, and code modules for workbook objects (e.g., Sheet1, thisWorkbook). |
| User Forms; | All UserForms (i.e., custom dialog boxes created with VBA). |
| Excel 5/95 Dialog Sheets | Sheets that store custom dialog boxes. Unless they are hidden, these sheets are visible in the workbook window (not in the VB Editor). |
| Excel 4 XLM Macro Sheets | Sheets that store XLM macros. Unless they are hidden, these sheets are visible in the workbook window (not in the VB Editor). |
This is only one feature of Kutools for Excel
It includes more than 100 functions and tools for Excel 2007 and 2010.
