B
Brad E.
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).OnAction = 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?
differently than the default.
I have put the following code in PERSONAL.XLSB.
Sub CommaStyleChange()
Application.CommandBars.FindControl(ID:=397).OnAction = 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?