本帖最后由 爱疯 于 2016-11-17 21:18 编辑
Private Sub Workbook_Open()
With Application.CommandBars(1).Controls.Add(Type:=msoControlPopup, temporary:=True)
.Caption = "【hcx工具】"
With .Controls.Add(Type:=msoControlButton, temporary:=True)
.Caption = "制作工资栏"
.FaceId = 51
.OnAction = "模块1.test2_1" '2_1表示第2层菜单中的第1项,以下同理
End With
With .Controls.Add(Type:=msoControlPopup, temporary:=True)
.Caption = "分页小计"
With .Controls.Add(Type:=msoControlButton, temporary:=True)
.Caption = "功能3_1"
.FaceId = 52
.OnAction = "模块1.test3_1"
End With
With .Controls.Add(Type:=msoControlButton, temporary:=True)
.Caption = "功能3_2"
.FaceId = 53
.OnAction = "模块1.test3_2"
End With
End With
With .Controls.Add(Type:=msoControlButton, temporary:=True)
.Caption = "一键还原内置菜单栏"
.FaceId = 54
.OnAction = "模块1.test2_3"
End With
End With
End Sub
caidan.rar
(8.63 KB, 下载次数: 5)