This post will guide you how to remove all macros within worksheet or workbook in Excel. How do I remove all VBA modules from an Excel Workbook.
Remove All Macros
You may be want to know if there was a way to get rid of all the macros in your current Excel Workbook. This post will show you one way to accomplish this task. Just do these steps:
Step1: go to View tab in the Excel Ribbon, and click Macros button under the Macros group. And choose View Macros from the dropdown menu list. And the Macro dialog will open.
Step2: then you can select one macro name that you want to delete from the list box of Macro name, and click Delete button.
Step3: you would see that the selected macro is deleted from your workbook.
There is another approach to remove macros with the existing workbook, just do the following steps:
Step1: open your excel workbook and then click on “Visual Basic” command under DEVELOPER Tab, or just press “ALT+F11” shortcut.
Step2: then the “Visual Basic Editor” window will appear.
Step3: right click on a module that you want to delete in the Project Explorer, right click on it, and choose the Remove option from the Context menu.
Step4: click on No button, when asked if you want to export the module before removing it.
Step5: repeat the above steps for any other modules that you want to delete.
Step6: close the VBA Editor.