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