I want my Excel 2007 "Comma Style" and "Percent Style" buttons to work
differently than the default.

I have put the following code in PERSONAL.XLSB.

Sub CommaStyleChange()
Application.CommandBars.FindControl(ID:=397).OnAct ion = MyCommaStyle
End Sub
---------------
Sub MyCommaStyle()
ActiveCell.NumberFormat = "#,##0" 'I don't want decimals or a
leading/trailing space for parenthesis
End Sub

The "Comma Style" button still changes the format to Excel's standard. How
do I get this to work for me everytime I use Excel? Also, since I will want
to do the same for Percent, can someone find the ID number for that?
--
Thank you, Brad E.