FREE Excel STUFF

Search

PRODUCTS

Development

Contact

Excel Online

Delete Module After Running VBA Code

Search Tips   Complete Excel Excel Training Course. Instant Buy/Download, 30 Day Money Back Guarantee FREE DOWNLOADS SmartVBA | SmartVB6 | CodeVBA | CodeVB6 | Code Generator Pro | TraderXL Pro Package. MORE..

Excel VBA: Delete Module After Running VBA Code. Deleting Modules via VBA Code

Current Special! Complete Excel Excel Training Course for Excel 97 - Excel 2003, only $145.00. $59.95 Instant Buy/Download

Delete Module via Code. See Also Delete Sheet Event Code With Code & Delete Workbook Event 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 go to Tools>Macro>Security - Trusted Publishers and check Trust access to Visual Basic Editor before running the code. Change "Module1" to suit.

Sub DeleteThisModule()

Dim vbCom As Object

     

    MsgBox "Hi, I will delete myself "

     

    Set vbCom = Application.VBE.ActiveVBProject.VBComponents

    

    vbCom.Remove VBComponent:= _

    vbCom.Item("Module1")

     

End Sub

Excel Dashboard Reports & Excel Dashboard Charts 50% Off

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.

Instant Download and Money Back Guarantee on Most Software

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Search Tips FREE Excel Help

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft