maaf mas slamet, bisa di aplikasikan dengan attacment saya ? trims 2009/2/25 Slamet Harto <[email protected]>
> 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 > > -- --------------------------------------------- grapyak-semanak-cluthak http://djmumun.wordpress.com ---------------------------------------------

