£ and $ command buttons

[Byrna West]

I would like to have both the £ and $ currency command buttons
available on the toolbar at the same time. Currently, the currency
button is defaulted as £. Is there anyway to have two currencies on
the toolbar?

thanks!

 

[JE McGimpsey]

I would like to have both the £ and $ currency command buttons
available on the toolbar at the same time. Currently, the currency
button is defaulted as £. Is there anyway to have two currencies on
the toolbar?

By "currency command buttons" I assume you mean the buttons on the
Formatting toolbar which set the cell style.

You can create a new style, say 'Dollars', using your desired number
format, say

_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)

then create a new command button (Tools/Customize/Customize
Toolbars/Menus/Commands pane:

Categories: Macros
Commands: Custom Button

and assign the macro

Public Sub DollarStyle()
On Error Resume Next
Selection.Style = "Dollars"
End Sub

Copy and paste a face on the button (Ctrl-click the button and choose
Properties...) to suit...

 

[Fairgreen]

By "currency command buttons" I assume you mean the buttons on the
Formatting toolbar which set the cell style.

You can create a new style, say 'Dollars', using your desired number
format, say

_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)

then create a new command button (Tools/Customize/Customize
Toolbars/Menus/Commands pane:

Categories: Macros
Commands: Custom Button

and assign the macro

Public Sub DollarStyle()
On Error Resume Next
Selection.Style = "Dollars"
End Sub

Copy and paste a face on the button (Ctrl-click the button and choose
Properties...) to suit...

Thanks...I'm a bit confused as I've never done a macro before. ...
1. I know how to create new styles in the formatting toolbar, but I
don't see a way to save the new style (in this case, a dollar format)
and give it a name. It just appears for that one instance. How do I
save for future use?
2. When I create a new command button per your instructions, I'm a bit
confused as to the order of events. Do I go through the Customize
Toolbars menu? Or Macro's menu? When I follow your path, I'm unable
to copy in the macro you've written...