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
---------------------------------------------

Kirim email ke