|
很多破解版的,无法启用加载项。
我换了个思路,直接做成菜单,让excel2007加载显示出来,执行起来也方便。
再此和大家分享一下。
在thisworkbook中加入下列代码,自动会出来加载项
- Private Sub Workbook_Open()
- '**********************************
- On Error Resume Next
- Dim BarCtlBtn As CommandBarButton
- Dim BarCtlBtnP As CommandBarPopup
- Application.CommandBars("MyMenu").Delete
- With Application.CommandBars.Add("MyMenu", msoBarTop, False, False)
- '******************************
- '******************************
- Set BarCtlBtnP = .Controls.Add(Type:=msoControlPopup, id:=1)
- With BarCtlBtnP
- .Caption = "【菜单一】 "
- '.BeginGroup = False
- End With
- Set BarCtlBtn = BarCtlBtnP.Controls.Add(Type:=msoControlButton)
- With BarCtlBtn
- .Style = msoButtonIconAndCaption
- .Caption = "【菜单1-1】 "
- .FaceId = 247
- .OnAction = "Read_QMCODEREC"
- End With
- Set BarCtlBtn = BarCtlBtnP.Controls.Add(Type:=msoControlButton)
- With BarCtlBtn
- .Style = msoButtonIconAndCaption
- .Caption = "【菜单1-2】 "
- .FaceId = 247
- .OnAction = "UpdateQMCODEREC"
- End With
- '****************************菜单选项:*************************
- Set BarCtlBtnP = .Controls.Add(Type:=msoControlPopup, id:=1)
- With BarCtlBtnP
- .Caption = "【其它选项】 "
- '.BeginGroup = False
- End With
- Set BarCtlBtn = BarCtlBtnP.Controls.Add(Type:=msoControlButton)
- With BarCtlBtn
- .Style = msoButtonIconAndCaption
- .Caption = "【恢复菜单】"
- .FaceId = 3650
- .OnAction = "Yes_Click"
- End With
- Set BarCtlBtn = BarCtlBtnP.Controls.Add(Type:=msoControlButton)
- With BarCtlBtn
- .Style = msoButtonIconAndCaption
- .Caption = "【隐藏菜单】"
- .FaceId = 3648
- .OnAction = "No_Click"
- End With
- .Visible = True
- End With
- End Sub
- Private Sub Workbook_BeforeClose(Cancel As Boolean)
- On Error Resume Next
- Application.CommandBars("MyMenu").Delete
- Application.CommandBars("MyMenu2").Delete
- Application.DisplayFormulaBar = True
- '-------
- End Sub
复制代码
|
|