Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I assign a toolbar button to a custom number format I creat
How do I assign a toolbar button to a custom number format I created?
Brett |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I assign a toolbar button to a custom number format I creat
write a macro to do the formatting. As an example, in a general module
(insert=Module) Sub Btn_clck() selection.Numberformat = "$#,##0.00" End Sub then go to tools=customize with the dialog visible, you can go to the second tab and drag a button onto an existing toolbar (macros from the left window, button from the right window) Right click on the button and you can assign a macro there. (bottom of popup menu: assign macro) or you can create a new toolbar (from the first tab, click New). Then drag a button to that new toolbar. Right click on the button and you can assign a macro there. -- Regards, Tom Ogilvy "FuadsCurse" wrote: How do I assign a toolbar button to a custom number format I created? Brett |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - assign macro to custom toolbar button | Excel Discussion (Misc queries) | |||
Assign custom number format to the ribbon | Excel Discussion (Misc queries) | |||
Assign Add-In to Custom Toolbar Button Microsoft Office 2007 | Excel Discussion (Misc queries) | |||
How Do I Assign a Toolbar Button to a Custom Number Format I creat | Excel Discussion (Misc queries) | |||
Assign macro to toolbar custom button? | Excel Programming |