attaboy said:
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.
This is right from excel help file
Run a macro from a toolbar button
You can run a macro from a button on a built-in toolbar or a custom
toolbar. For information about creating a custom toolbar, click .
On the Tools menu, click Customize.
Show Me
If the toolbar that contains the button is not visible, click the
Toolbars tab, and then select the check box next to the toolbar name.
If the button you want to run the macro from is not on a toolbar, click
the Commands tab, and then click Macros in the Categories list. In the
Commands list, drag the Custom button onto a toolbar.
Right-click the toolbar button, and then click Assign Macro on the
shortcut menu.
In the Macro name box, enter the name of the macro.
-----------------------------------
use a macro like this
All I did was record the macro
Sub Format()
'
'
'
'
Selection.NumberFormat = "###,###"
End Sub