Delete a VBA Module From Excel

Add to Favorites
Delete a VBA macro module from Excel with this macro. This macro allows you to fully remove a macro module from Excel. This is great when you need to quickly clean up your macros, vba, or just leftover modules in Excel. You do need to be careful not to delete a module that contains important code. This is a great macro and is very powerful.

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







Similar Content on TeachExcel
Open a Word Document from Excel
Macro: This Microsoft Excel macro will open a Microsoft Word document from excel. With this m...
Open a PowerPoint Presentation from Excel
Macro: This free macro for Microsoft Excel allows you to open any PowerPoint presentation fro...
Open PDF from Excel
Tutorial: How to open a PDF file from a clickable button, link, or image in Excel.  This allows yo...
Delete All Chart Sheets in Excel - Only Chart Sheets are Deleted - Not Embedded Charts
Macro: Delete all chart sheets and tabs in Excel using this macro. This will only delete the...
Remove Comments from a Workbook in Excel - All Comments Deleted - Macro VBA
Macro: Excel macro that will remove/delete all of the comments from an entire Excel workbook....
Delete Comments in Excel - Permanently Remove Specific Comments from Excel
Macro: Delete a comment in Excel with this macro. You can permanently remove or delete a specific...



How to Install the Macro
  1. Select and copy the text from within the grey box above.

  2. Open the Microsoft Excel file in which you would like the Macro to function.

  3. Press "Alt + F11" - This will open the Visual Basic Editor - Works for all Excel Versions.  Or For other ways to get there, Click Here.

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

  5. If the Macro goes in a Module, Click Here, otherwise continue to Step 8.

  6. If the Macro goes in the Workbook or ThisWorkbook, Click Here, otherwise continue to Step 8.

  7. If the Macro goes in the Worksheet Code, Click Here, otherwise continue to Step 8.

  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.

  9. You are now ready to run the macro.


Similar Content
Open a Word Document from Excel
Macro: This Microsoft Excel macro will open a Microsoft Word document from excel. With this m...
Open a PowerPoint Presentation from Excel
Macro: This free macro for Microsoft Excel allows you to open any PowerPoint presentation fro...
Open PDF from Excel
Tutorial: How to open a PDF file from a clickable button, link, or image in Excel.  This allows yo...
Excel Forum