Excel VBA: Delete Module After Running VBA Code. Deleting Mo

Home » 编程开发 » Excel VBA: Delete Module After Running VBA Code. Deleting Mo

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.

    SubDeleteThisModule()DimvbComAsObjectMsgBox”Hi,Iwilldeletemyself”SetvbCom=Application.VBE.ActiveVBProject.VBComponentsvbCom.RemoveVBComponent:=_vbCom.Item(“Module1”)EndSub

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

可偏偏。多么温柔，一出口便是相互指责和嘲讽。

Excel VBA: Delete Module After Running VBA Code. Deleting Mo

相关文章：

你感兴趣的文章：

标签云：

亚洲高清电影在线, 免费高清电影, 八戒影院夜间, 八戒电影最新大片, 出轨在线电影, 午夜电影院, 在线影院a1166, 在线电影院, 在线观看美剧下载, 日本爱情电影, 日韩高清电影在线, 电影天堂网, 直播盒子app, 聚合直播, 高清美剧, 高清美剧在线观看 EhViewer-E站, E站, E站绿色版, qqmulu.com, qq目录网, qq网站目录,