New toolbar button

[Guest]

Can i create a new toolbar button which will format a cell in a particular
style?

I am trying to create a style similar to "Comma style" but without any
decimal places.

 

[Guest]

why not create such a style and apply it in the normal way.

or create it an link it to a button

Sub MyMacro()
selection..Style = "MyComma"
End Sub

go to tools => customize
command tab
right window go to Macros
left window, select custom button and drag it to a toolbar.

right click on the button and select assign macro.

assign the above macro. Make other modifications as desired

close the customize dialog.