biasanya saya kalo buat toolbar taruh di modul seperti ini:

Sub BuatToolBar()
   Dim ComBar As CommandBar
   Dim btnPop As CommandBarPopup
   Dim btnNew As CommandBarControl

   Set ComBar = CommandBars.Add(Name:="MyForm")
   ComBar.Visible = True

   Set btnNew = ComBar.Controls.Add(Type:=msoControlButton)
   With btnNew
      .Caption = "&Dindik"
      .Style = msoButtonIconAndWrapCaptionBelow
      .OnAction = ThisWorkbook.Name & "!!submacro1" 'untuk panggil macronya
      End With
      Set btnNew = ComBar.Controls.Add(Type:=msoControlButton)
      With btnNew
      .Caption = "Distanhut"
      .Style = msoButtonIconAndWrapCaptionBelow
      .OnAction = ThisWorkbook.Name & "!submacro2"
    End With

    ComBar.Position = msoBarTop
    ComBar.Left = 0
    ComBar.Protection = msoBarNoMove
    Set btnNew = Nothing
    Set ComBar = Nothing

End Sub

tampilannya bisa dipercantik lagi dengan Face-ID

untuk pertanyaan lain, maaf saya nggak mudeng yang dimau apa?

wassalam

Kirim email ke