Sub auto_open()
Call addbutton
End Sub
Sub addbutton()
Dim popup As CommandBarPopup
Dim button As CommandBarButton
With Application.CommandBars("Worksheet Menu Bar").Controls.Add(Type:=msoControlPopup, Before:=11)
.Caption = "DIY"
End With
Set popup = Application.CommandBars(1).Controls("DIY")
Set button = popup.Controls.Add(msoControlButton)
With button
.Caption = "宏1"
.OnAction = "宏1名"
.BeginGroup = False
.Visible = False 'false 不可见
.Enabled = True 'false 按钮变灰
End With
End Sub
Sub auto_close()
Call DeleteToolbars
End Sub
Sub DeleteToolbars()
On Error Resume Next
Application.CommandBars(1).Controls("DIY").Delete