icon do not show of toolbar

[lior03]

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.
[VBA]
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

[/VBA]
thanks

[Bob Phillips]

Is format one of your commandbars or do you really mean Formatting? It works for me.

[ALe]

Xld is right. The name of the bar is "Formatting" and not "Format"

[lior03]

thank you very much.
can i decide where to locate the icon .i want it to be the secnnd from left.could it be doen.
thanks again

[TonyJollans]

To position your new Control second from left, use [vba]With Application.CommandBars("Formatting").Controls.Add(Before:=2)[/vba]However, if you are using Adaptive Menus there is no guarantee it will maintain that position.