Sub ShowMyCustomToolbar()
Dim myToolbar As CommandBar
On Error Resume Next
Set myToolbar = CommandBars("My Custom Toolbar")
On Error GoTo 0
If myToolbar Is Nothing Then
' Create the toolbar
Set myToolbar = CommandBars.Add(Name:="My Custom Toolbar", Position:=msoBarTop, Temporary:=True)
' Add a sample button to the toolbar
With myToolbar.Controls.Add(Type:=msoControlButton)
.Caption = "My Button"
.Style = msoButtonCaption
.OnAction = "MyButtonMacro"
End With
End If
' Show the toolbar
myToolbar.Visible = True
End Sub
Sub MyButtonMacro()
MsgBox "You clicked the button!"
End Sub