Excel VBA: delete module after running VBA code. Deleting modules via VBA code

The code below can be used to delete the module which houses the Code. In other words, it deletes itself after running once.

You will have to goTools>Macro>Security-Trusted publishersAnd check trust accessVisual Basic EditorBefore running the code. Change"Module1"To suit.

1. Sub deletethismodule ()
3. Dim vbcom as object
7. Msgbox "hi, I will delete myself"
11. Set vbcom = application. VBE. activevbproject. vbcomponents
15. Vbcom. Remove vbcomponent: = _
17. Vbcom. Item ("module1 ")
21. End sub

 

From: http://www.ozgrid.com/VBA/delete-module.htm