- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¦^´_ 1# yangjie - Option Explicit
- Sub MakeMenu1()
- Dim bar As CommandBarControl
- Dim NewMenu1 As CommandBarControl
- Dim MenuCount As Integer
- Dim i As Integer
- For Each bar In Application.CommandBars(1).Controls
- bar.Visible = False
- Next
- On Error Resume Next
- Application.CommandBars(1).Controls("¦^¥D¿ï³æ").Delete
- On Error GoTo 0
- MenuCount = Application.CommandBars(1).Controls.Count
- Set NewMenu1 = Application.CommandBars(1).Controls.Add(Type:=msoControlPopup, before:=MenuCount, Temporary:=True)
- 'Set NewMenu1 = Application.CommandBars(1).Controls.Add(Type:=10, before:=MenuCount, Temporary:=True)
- With NewMenu1
- .Caption = "¦^¥D¿ï³æ"
- ' .OnAction = "myForm1"
- With .Controls.Add(Type:=msoControlButton)
- .FaceId = 264
- .Caption = "¦^¥D¿ï³æ A"
- .OnAction = "myForm1"
- End With
- With .Controls.Add(Type:=msoControlButton)
- .FaceId = 207
- .Caption = "¦^¥D¿ï³æ B"
- .OnAction = "myForm1"
- End With
- End With
- End Sub
½Æ»s¥N½X |
|