MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Currency Button

Posted by Sean Clarke on September 11, 2001 2:00 AM

The default currency button on the toolbar when clicked, sets the format of the cell(s) to accounting rather than currency.

Is there any way to change this to set it to a currency value ?

Posted by JAF on September 12, 2001 4:20 AM

I had the same problem. The solution I used was to record a macro to use the format that I wanted as (basic version shown below), and then to customize the toolbar.

NB macro should be saved in Personal Macro Workbook so that it's always available)

To customize, right click on any toolbar and select Customize from the shortcut menu that appears. The right click on the Currency button and select Assign Macro. Select the macro you previously recorded, click OK and away you go.

Sub My_Currency_Macro()
Selection.NumberFormat = "$#,##0.00"
End Sub

you can of course make the macro more complex by including checks to ensure that the worksheet is not protected if you like...