例子: Dim NewMenuItem As CommandBarButton Dim XlApp As Object Set XlApp = CreateObject("Excel.Application") XlApp.CommandBars("File").Reset XlApp.CommandBars("Edit").Reset
'增加菜单"报表定义" Set NewMenuItem = XlApp.CommandBars("File").Controls.Add(Type:=msoControlButton, Before:=3) With NewMenuItem .Style = msoButtonIconAndCaption .OnAction = "Func报表管理" '执行该菜单功能的宏名 .Caption = "报表管理" .Enabled = True .Tag = "报表管理" End With 再在Excel的启动宏中定义一个函数即可,函数名为"Func报表管理"
然后在“自定义工具栏”中设置即可!
Dim NewMenuItem As CommandBarButton
Dim XlApp As Object Set XlApp = CreateObject("Excel.Application")
XlApp.CommandBars("File").Reset
XlApp.CommandBars("Edit").Reset
'增加菜单"报表定义"
Set NewMenuItem = XlApp.CommandBars("File").Controls.Add(Type:=msoControlButton, Before:=3)
With NewMenuItem
.Style = msoButtonIconAndCaption
.OnAction = "Func报表管理" '执行该菜单功能的宏名
.Caption = "报表管理"
.Enabled = True
.Tag = "报表管理"
End With
再在Excel的启动宏中定义一个函数即可,函数名为"Func报表管理"