Sub Test()
Dim VBProj As VBIDE.VBProject
Dim VBComp As VBIDE.VBComponent
Dim CodeMod As VBIDE.CodeModule
Dim LineNum As Long
Dim NewName As String
Set VBProj = ActiveWorkbook.VBProject
Set VBComp = VBProj.VBComponents("Module1")
Set CodeMod = VBComp.CodeModule
NewName = "Sub VBE()"
With CodeMod
.DeleteLines 1
LineNum = .CountOfLines - 17
.InsertLines LineNum, NewName
End With
End Sub