lior03
03-30-2006, 04:06 AM
hello
i added a new button to the format toolbar in excel.it do not show on the toolbar.when i added it to the visual basic toolbar it appeared.
why?
is the a limit to how many icon i can add to a toolbar.
Sub f()
With Application.CommandBars("format").Controls.add
.Caption = "cell's number format"
.FaceId = 580
.Style = msoButtonIcon
.OnAction = "numberformation"
.BeginGroup = True
End With
End Sub
thanks
i added a new button to the format toolbar in excel.it do not show on the toolbar.when i added it to the visual basic toolbar it appeared.
why?
is the a limit to how many icon i can add to a toolbar.
Sub f()
With Application.CommandBars("format").Controls.add
.Caption = "cell's number format"
.FaceId = 580
.Style = msoButtonIcon
.OnAction = "numberformation"
.BeginGroup = True
End With
End Sub
thanks