 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / October 2007£ and $ command buttons
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! > 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... > In article <1193664113.544159.224...@v3g2000hsg.googlegroups.com>, > [quoted text clipped - 26 lines] > 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... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.