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