Создание кнопки:
[vba]Код
Sub Макрос_Create()
Dim combar As CommandBar, but As CommandBarButton
Set combar = Application.CommandBars("Standard")
Set but = combar.Controls.Add(Type:=msoControlButton)
With but
.Style = msoButtonIconAndCaption
.Caption = "Возврат"
.FaceId = 2134
.TooltipText = "Кнопка"
.OnAction = "Module1.Macro_TestCommandBar"
.BeginGroup = True
End With
End Sub
[/vba]
Удаление кнопки:
[vba]Код
Sub Макрос_Del()
Dim combar As CommandBar
Set combar = Application.CommandBars("Standard")
combar.Controls("Возврат").Delete
End Sub
[/vba]