以下是引用amulee在2010-8-23 15:24:00的发言: '创建菜单 Sub CreateMenu() Dim Menu As CommandBarButton Set Menu = Application.CommandBars(1).Controls.Add( _ Type:=msoControlButton, temporary:=True) Menu.Caption = "继续" Menu.FaceId = 186 Menu.OnAction = "Exce" End Sub '删除菜单 Sub DeleteMenu() On Error Resume Next Application.CommandBars(1).Controls("继续").Delete On Error GoTo 0 End Sub '执行继续按钮 Sub Exce() Application.VBE.CommandBars(4).Controls(3).Execute End Sub 感谢感谢阿木老师,这样都做到了。谢谢谢谢。 |