Format the command for the Currency button
 

In Excel 2003, there was a way to change the commands linked to a button. So for instance, I like making my negative numbers red, so I reformatted the Currency button to make all the negative numbers red.

I now have 2007 and I am battling. I have found a way to edit the Currency button but it does not keep the setting if I close Excel.

Please can somebody advise how I can make this permanent

Thanks
Murray

Format the command for the Currency button
 

You do not have to "edit the currency button". In fact doing so is a bit
more complicated in Excel 2007.

When you click the "$" button in the Number group on the Home tab (this is
what I assume you're referring to), it applies the Accounting number format
to the selected cells. So, for the current workbook, all you have to do is
edit the Accounting style.

Since this is a bit of a hassle, run this macro instead once in each
workbook you want this change in.

Sub ChgAcctingStyle()
ActiveWorkbook.Styles("Currency").NumberFormat = _
"_($* #,##0.00_);[Red]_($* (#,##0.00);_($* ""-""??_);_(@_)"
End Sub

If you're not in the US I assume you can make whatever adjustments you need
for your locale.


--
Jim
"Murray" wrote in message
...
In Excel 2003, there was a way to change the commands linked to a button. So
for instance, I like making my negative numbers red, so I reformatted the
Currency button to make all the negative numbers red.

I now have 2007 and I am battling. I have found a way to edit the Currency
button but it does not keep the setting if I close Excel.

Please can somebody advise how I can make this permanent

Thanks
Murray

Format the command for the Currency button
 

Thanks for getting back to me Jim.

Is it possible to put a "blank" button on the toolbar and assign your macro
to it, like you used to be able to in older versions of Excel?

Also, if I modify the format in a blank workbook and then save that workbook
as the Excel default, will it keep that format in all new workbooks?

Regards
Murray


"Jim Rech" wrote in message
...
You do not have to "edit the currency button". In fact doing so is a bit
more complicated in Excel 2007.

When you click the "$" button in the Number group on the Home tab (this is
what I assume you're referring to), it applies the Accounting number
format
to the selected cells. So, for the current workbook, all you have to do
is
edit the Accounting style.

Since this is a bit of a hassle, run this macro instead once in each
workbook you want this change in.

Sub ChgAcctingStyle()
ActiveWorkbook.Styles("Currency").NumberFormat = _
"_($* #,##0.00_);[Red]_($* (#,##0.00);_($* ""-""??_);_(@_)"
End Sub

If you're not in the US I assume you can make whatever adjustments you
need
for your locale.


--
Jim
"Murray" wrote in message
...
In Excel 2003, there was a way to change the commands linked to a button.
So
for instance, I like making my negative numbers red, so I reformatted the
Currency button to make all the negative numbers red.

I now have 2007 and I am battling. I have found a way to edit the Currency
button but it does not keep the setting if I close Excel.

Please can somebody advise how I can make this permanent

Thanks
Murray

Format the command for the Currency button
 

Is it possible to put a "blank" button on the toolbar

You would want to customize your QAT (Quick Access Toolbar). Ron de Bruin
has instructions he

http://www.rondebruin.nl/imageqat.htm

From the "Choose commands from" drop down you should pick Macros and point
to yours.

Any modification you make to your startup template (Book.xltx) should be
there when you create a new workbook from it.

--
Jim
"Murray" wrote in message
...
| Thanks for getting back to me Jim.
|
| Is it possible to put a "blank" button on the toolbar and assign your
macro
| to it, like you used to be able to in older versions of Excel?
|
| Also, if I modify the format in a blank workbook and then save that
workbook
| as the Excel default, will it keep that format in all new workbooks?
|
| Regards
| Murray
|
|
| "Jim Rech" wrote in message
| ...
| You do not have to "edit the currency button". In fact doing so is a
bit
| more complicated in Excel 2007.
|
| When you click the "$" button in the Number group on the Home tab (this
is
| what I assume you're referring to), it applies the Accounting number
| format
| to the selected cells. So, for the current workbook, all you have to do
| is
| edit the Accounting style.
|
| Since this is a bit of a hassle, run this macro instead once in each
| workbook you want this change in.
|
| Sub ChgAcctingStyle()
| ActiveWorkbook.Styles("Currency").NumberFormat = _
| "_($* #,##0.00_);[Red]_($* (#,##0.00);_($* ""-""??_);_(@_)"
| End Sub
|
| If you're not in the US I assume you can make whatever adjustments you
| need
| for your locale.
|
|
| --
| Jim
| "Murray" wrote in message
| ...
| In Excel 2003, there was a way to change the commands linked to a
button.
| So
| for instance, I like making my negative numbers red, so I reformatted
the
| Currency button to make all the negative numbers red.
|
| I now have 2007 and I am battling. I have found a way to edit the
Currency
| button but it does not keep the setting if I close Excel.
|
| Please can somebody advise how I can make this permanent
|
| Thanks
| Murray
|
|
|

Format the command for the Currency button
 

This seriously looks like a whole lot of steps backwards to go a few short
steps forwards!

Thanks for your help though.

Regards



"Jim Rech" wrote in message
...
Is it possible to put a "blank" button on the toolbar

You would want to customize your QAT (Quick Access Toolbar). Ron de Bruin
has instructions he

http://www.rondebruin.nl/imageqat.htm

From the "Choose commands from" drop down you should pick Macros and point
to yours.

Any modification you make to your startup template (Book.xltx) should be
there when you create a new workbook from it.

--
Jim
"Murray" wrote in message
...
| Thanks for getting back to me Jim.
|
| Is it possible to put a "blank" button on the toolbar and assign your
macro
| to it, like you used to be able to in older versions of Excel?
|
| Also, if I modify the format in a blank workbook and then save that
workbook
| as the Excel default, will it keep that format in all new workbooks?
|
| Regards
| Murray
|
|
| "Jim Rech" wrote in message
| ...
| You do not have to "edit the currency button". In fact doing so is a
bit
| more complicated in Excel 2007.
|
| When you click the "$" button in the Number group on the Home tab
(this
is
| what I assume you're referring to), it applies the Accounting number
| format
| to the selected cells. So, for the current workbook, all you have to
do
| is
| edit the Accounting style.
|
| Since this is a bit of a hassle, run this macro instead once in each
| workbook you want this change in.
|
| Sub ChgAcctingStyle()
| ActiveWorkbook.Styles("Currency").NumberFormat = _
| "_($* #,##0.00_);[Red]_($* (#,##0.00);_($* ""-""??_);_(@_)"
| End Sub
|
| If you're not in the US I assume you can make whatever adjustments you
| need
| for your locale.
|
|
| --
| Jim
| "Murray" wrote in message
| ...
| In Excel 2003, there was a way to change the commands linked to a
button.
| So
| for instance, I like making my negative numbers red, so I reformatted
the
| Currency button to make all the negative numbers red.
|
| I now have 2007 and I am battling. I have found a way to edit the
Currency
| button but it does not keep the setting if I close Excel.
|
| Please can somebody advise how I can make this permanent
|
| Thanks
| Murray
|
|
|