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

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