我现在给你一段我昨天写成的代码:
'使XXX系统菜单下的第二项菜单中的,第一个子菜单不可用:
set mymenu=commandbars("XX系统菜单").controls(2).commandbar.controls(1)
with mymenu
.enabled=false
end with
'添加一个子菜单
set newitem=commandbars("XX系统菜单").controls(1).commandbar.controls.add()
with newitem
.begingroup=true '开始一个新组
.caption="new item" '菜单名
.onaction="qtrReport" '所进行的操作
.enable=true
end with
Public Sub CreateMenu()
Dim xMenubar As Office.CommandBar
Dim xMenu As Office.CommandBarPopup
Dim xMenuItem As Office.CommandBarButton
Set xMenubar = Application.CommandBars("Menu Bar")
Set xMenu = xMenubar.Controls.Add(msoControlPopup)
xMenu.Caption = "系统设置(&S)"
Set xMenuItem = xMenu.Controls.Add(msoControlButton)
With xMenuItem
.Caption = "国家设置"
'.OnAction '过程名称
.FaceId = 200
End With
Set xMenuItem = xMenu.Controls.Add(msoControlButton)
With xMenuItem
.Caption = "城市设置"
'.OnAction = '过程名称
.BeginGroup = True '是否开始一组(分隔线)
.FaceId = 300 '指定图标
End With
End Sub