Delete a VBA Module From Excel
To use this macro, you need to do two things. First, replace Module1 with the name of the actual module which you want to delete. If you wanted, you could include this in a loop in order to delete all modules from the workbook in Excel. Second, you need to enable access to the vba project object model - > In previous versions of Excel go to Tools > Macro > Security - Trusted Publishers check the box next to "Trust access to Visual Basic Editor". In Excel 2007 go to Office Button > Excel Options > Trust Center > Trust Center Settings > Macro Setting and check the box next to "Trust access to the VBA project object model".
Where to install the macro: Module
Excel Macro to Delete a VBA Module From Excel
Sub Delete_Module()
Dim vbCom As Object
Set vbCom = Application.VBE.ActiveVBProject.VBComponents
vbCom.Remove VBComponent:= _
vbCom.Item("Module1")
End Sub
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Macro: This Microsoft Excel macro will open a Microsoft Word document from excel. With this m...
Macro: This free macro for Microsoft Excel allows you to open any PowerPoint presentation fro...
Tutorial: How to connect to a MySQL database from Excel, fetch the latest data from it, and work wi...
Tutorial: How to open a PDF file from a clickable button, link, or image in Excel. This allows yo...
Macro: Excel macro that will remove/delete all of the comments from an entire Excel workbook....
Macro: Delete all chart sheets and tabs in Excel using this macro. This will only delete the char...
How to Install the Macro
- Select and copy the text from within the grey box above.
- Open the Microsoft Excel file in which you would like the Macro to function.
- Press "Alt + F11" - This will open the Visual Basic Editor - Works for all Excel Versions.
Or For other ways to get there, Click Here.
- On the new window that opens up, go to the left side where the vertical pane is located. Locate your Excel file; it will be called VBAProject (YOUR FILE'S NAME HERE) and click this.
- If the Macro goes in a Module, Click Here, otherwise continue to Step 8.
- If the Macro goes in the Workbook or ThisWorkbook, Click Here, otherwise continue to Step 8.
- If the Macro goes in the Worksheet Code, Click Here, otherwise continue to Step 8.
- Close the Microsoft Visual Basic Editor window and save the Excel file. When you close the Visual Basic Editor window, the regular Excel window will not close.
- You are now ready to run the macro.
Macro: This Microsoft Excel macro will open a Microsoft Word document from excel. With this m...
Macro: This free macro for Microsoft Excel allows you to open any PowerPoint presentation fro...
Tutorial: How to connect to a MySQL database from Excel, fetch the latest data from it, and work wi...
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)