.onAction = "yourFunction"
可以写yourFunction做你想做的处理
Public cbcMenu As CommandBar
Public cbcPopup As CommandBarPopup
Public cbcButton As CommandBarControlPrivate Sub Workbook_Open() Set cbcMenu = Application.CommandBars.Add(Name:="ExcelHelp", Position:=msoBarTop, Temporary:=True)
Set cbcPopup = cbcMenu.Controls.Add(Type:=msoControlPopup, Temporary:=True)
cbcPopup.Caption = "文 件"
Set cbcButton = cbcPopup.CommandBar.Controls.Add(Type:=msoControlButton, Temporary:=True)
cbcButton.Caption = "新 增"
cbcButton.OnAction = "test"
cbcMenu.Visible = True
End SubSub test()
MsgBox "delasd"
End Sub
可以写yourFunction做你想做的处理
Public cbcMenu As CommandBar
Public cbcPopup As CommandBarPopup
Public cbcButton As CommandBarControlPrivate Sub Workbook_Open() Set cbcMenu = Application.CommandBars.Add(Name:="ExcelHelp", Position:=msoBarTop, Temporary:=True)
Set cbcPopup = cbcMenu.Controls.Add(Type:=msoControlPopup, Temporary:=True)
cbcPopup.Caption = "文 件"
Set cbcButton = cbcPopup.CommandBar.Controls.Add(Type:=msoControlButton, Temporary:=True)
cbcButton.Caption = "新 增"
cbcButton.OnAction = "test"
cbcMenu.Visible = True
End SubSub test()
MsgBox "delasd"
End Sub
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货