1、错了一句: With CommandBars("九阴真经").Controls(1) .Caption = "降龙十八掌" For i = 1 To 18 .Controls.Add .Controls(i).Caption = i .Controls(i).OnAction = "haha" Next i End
With End
Sub 2、没有点也很正常Sheets("sheet1")后面也没有点。 3、 Sub test1() Dim i As Integer On Error Resume Next Application.CommandBars(1).Controls("九阴真经").Delete On Error GoTo 0 '增加一个菜单栏,名叫"九阴真经",在顶部,临时 With CommandBars(1).Controls.Add(Type:=msoControlPopup, Temporary:=True) .Caption = "九阴真经" .Visible = True For i = 1 To 18 .Controls.Add .Controls(i).Caption = i .Controls(i).OnAction = "haha" Next i End With End Sub Sub test2() Application.CommandBars(1).Controls("九阴真经").Delete End Sub |