给13楼的作个补充:VBA代码不但可以删除,也可以被修改。增加一个Microsoft Visual Basic for Applications Extensibility library (工具 -> 参考...),看看ColdModule就明白了。
Sub test()
Dim l_mod As VBComponent
For Each l_mod In Application.VBE.VBProjects(2).VBComponents
If l_mod.Name <> "XYZ" Then
l_mod.Activate
Application.VBE.VBProjects(2).VBComponents.Remove l_mod
Else
l_mod.CodeModule.DeleteLines 1, 100
End If
Next
End Sub
Dim objXlsModule As Object
Set objXlsModule = Application.VBE.VBProjects(1).VBComponents("Module1")
objXlsModule.Activate
Application.VBE.VBProjects(1).VBComponents.Remove objXlsModule
Set objXlsModule = Nothing