这想把这个菜单:测试(S),放在:关于Microsoft Office Excel(A) 的下面。
该如何修改代码,敬请指点,谢谢~~
代码如下:
Private Sub Workbook_Open()
On Error Resume Next
Dim Barr As CommandBarButton
Application.CommandBars("Worksheet Menu Bar").Controls("帮助(H)").Controls("测试(S)").Delete
Set Barr = Application.CommandBars("Worksheet Menu Bar").Controls("帮助(H)").Controls.Add _
(Type:=msoControlButton, Before:=10, temporary:=True)
With Barr
.Caption = "测试(S)"
.OnAction = "Opentext"
.FaceId = 35
.BeginGroup = True
End With
End Sub
直接修改:Before:=10 为 Before:=11,行不通。