How do I assign a toolbar button to a custom number format I creat

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Back
Top