'工具-宏-安全性-可靠发行商-(勾选 信任对于“Visual Basic”项目的访问) Sub test() Dim ovbcomp As Variant Dim i As Integer, j As Integer Dim sMsg As String Dim sTmp As String Dim sLik(2) As String sLik(0) = "Sub " sLik(1) = "Public Sub " sLik(2) = "Private Sub " For Each ovbcomp In ThisWorkbook.VBProject.VBComponents For i = 1 To ovbcomp.CodeModule.CountOfLines sTmp = ovbcomp.CodeModule.Lines(i, 1) For j = 0 To 2 If sTmp Like sLik(j) & "*" Then sTmp = Replace(sTmp, "()", "") sTmp = Replace(sTmp, sLik(j), "") sMsg = sMsg + sTmp + vbCrLf End If Next Next Next MsgBox sMsg End Sub
|