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
|
|
|