在thisWorkbook页下的代码,打开EXCEL就激活以下程序
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call Deletemenu
End Sub
Private Sub Workbook_Open()
Call createmenu
'Sheet1.Visible = xlSheetVeryHidden
Sheet1.Visible = xlSheetVisible
End Sub
在模块下的程序
Public Menuobject As CommandBarPopup
Public memuitem As Object
Public SubMenuItem As Object
Public ActivateForm1 As Object
Public Sub createmenu()
Call Deletemenu
Set Menuobject = Application.CommandBars(1).Controls.Add(Type:=msoControlPopup, before:=11, temporary:=True)
Menuobject.Caption = "操作"
Set MenuItem = Menuobject.Controls.Add(Type:=msoControlButton)
MenuItem.Caption = "AAAA"
MenuItem.OnAction = "AAAA"
Set Menuobject = Nothing
Set SubMenuItem = Nothing
End Sub
Public Sub Deletemenu()
On Error Resume Next
Application.CommandBars(1).Controls("操作").Delete
On Error GoTo 0
End Sub