|
那就用
Private Sub Workbook_Open()
Dim P
On Error Resume Next
Application.CommandBars("Worksheet Menu Bar").Controls("综合统计").Delete
Dim Button As CommandBarControl
Set P = Application.CommandBars("Worksheet Menu Bar").Controls.Add(Type:=msoControlPopup)
P.Caption = "综合统计"
Call MyButton(P, "统计", 226, "HZ")
Call MyButton(P, "清除", 478, "QC")
Call MyButton(P, "保存", 455, "BF")
End Sub
Sub MyButton(MyPopup, Caption As String, FaceId As Integer, OnAction As String)
Set Button = MyPopup.Controls.Add(Type:=msoControlButton)
Button.Caption = Caption
Button.FaceId = FaceId
Button.OnAction = OnAction
End Sub |
|