Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 | | | |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to format cells in Excel 2007 (i.e. currency format)? | Excel Discussion (Misc queries) | |||
Currency Style Button | Excel Discussion (Misc queries) | |||
why does the toolbar have a button, $ and is said currency,it giv. | Excel Worksheet Functions | |||
Currency button | Excel Worksheet Functions | |||
Currency Style button | Excel Discussion (Misc queries) |