在Excel Shared Add-in中的现有菜单中创建子菜单
我正在开发一个Excel共享加载项，其中包含使用Excel宏创建的名为
Custom
Custom
oStandardBar = oCommandBars["Custom"];
oCmdBarCtrl = oStandardBar.Controls.Add(MsoControlType.msoControlPopup, Type.Missing, Type.Missing, Type.Missing, true);
oCmdBarCtrl.Visible = false;
oCmdBarCtrl.Caption = "Sub Menu1";
没有找到相关结果
已邀请:
1 个回复
念炯
var m_toolbar = this.Application.CommandBars.Add("WpfAddIn", Office.MsoBarPosition.msoBarTop, false, true); var mainMenu = (Office.CommandBarPopup)m_toolbar.Controls .Add(Office.MsoControlType.msoControlPopup, missing, missing, missing, true); mainMenu.Caption = "Main menu"; var subMenu1 = (Office.CommandBarButton)mainMenu.Controls .Add(Office.MsoControlType.msoControlButton, missing, missing, missing, true); subMenu1.Caption = "Sub menu 1"; subMenu1.FaceId = 1958; var subMenu2 = (Office.CommandBarPopup)mainMenu.Controls .Add(Office.MsoControlType.msoControlPopup, missing, missing, missing, true); subMenu2.BeginGroup = true; subMenu2.Caption = "Sub menu 2"; var subMenu2Button = (Office.CommandBarButton)subMenu2.Controls .Add(Office.MsoControlType.msoControlButton, missing, missing, missing, true); subMenu2Button.Caption = "Sub menu 1"; subMenu2Button.FaceId = 1958; m_toolbar.Visible = true;