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
|