这是n年前写的一加载宏中的代码,这两个过程放在Thisworkbook里;<br/>相应的过程写在“模块”中。<br/><br/>Private Sub Workbook_AddinInstall()<br/>'加载宏安装时,插入自定义菜单<br/> Dim mb As Object, myctl As Object<br/> Dim i As Integer, j As Integer<br/> '如果非正常原因导致菜单残留,则先删除<br/> With Application.CommandBars(1)<br/> i = .Controls.Count<br/> For j = 1 To i<br/> If .Controls(j).Caption = "Input(&R)" Then<br/> .Controls(j).Delete<br/> End If<br/> Next<br/> '插入自定义菜单<br/> i = .Controls.Count<br/> Set myctl = .Controls.Add(Type:=msoControlPopup, before:=i)<br/> myctl.Caption = "Input(&R)"<br/><br/> Set mb = myctl.Controls.Add(Type:=msoControlButton)<br/> '子菜单名称<br/> mb.Caption = "Test1 ..."<br/> '子菜单调用的过程<br/> mb.OnAction = "test1"<br/><br/> Set mb = myctl.Controls.Add(Type:=msoControlButton)<br/> mb.Caption = "Test1 ..."<br/> mb.OnAction = "test2"<br/><br/> Set mb = myctl.Controls.Add(Type:=msoControlButton)<br/> mb.Caption = "Test3 ..."<br/> mb.OnAction = "test3"<br/> <br/> Set mb = myctl.Controls.Add(Type:=msoControlButton)<br/> mb.Caption = "Test4 ..."<br/> mb.OnAction = "test4"<br/> <br/> Set mb = myctl.Controls.Add(Type:=msoControlButton)<br/> mb.Caption = "Test5"<br/> mb.OnAction = "test5"<br/> <br/> Set mb = myctl.Controls.Add(Type:=msoControlButton)<br/> mb.Caption = "Test6 ..."<br/> mb.OnAction = "test6"<br/> <br/> <br/> <br/> End With<br/><br/><br/>End Sub<br/><br/>Private Sub Workbook_AddinUninstall()<br/>'卸载加载宏时,卸载自定义菜单<br/> Dim i As Integer, j As Integer<br/> With Application.CommandBars(1)<br/> i = .Controls.Count<br/> For j = 1 To i<br/> If .Controls(j).Caption = "Input(&R)" Then<br/> .Controls(j).Delete<br/> Exit For<br/> End If<br/> Next<br/> End With<br/>End Sub<br/><br/>也可以把加入菜单和卸载菜单代码写在activate和deactivate事件里,那么特定菜单在该工作簿处于激活状态就加载,当切换到其他工作簿时,菜单自动卸载。