New button on toolbar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can i create a new toolbar button which will format a cell in a particular
style?

I am trying to create a style similar to "Comma style" but without any
decimal places.
 
attaboy said:
Can i create a new toolbar button which will format a cell in a particular
style?

I am trying to create a style similar to "Comma style" but without any
decimal places.
Click to expand...


This is right from excel help file


Run a macro from a toolbar button
You can run a macro from a button on a built-in toolbar or a custom
toolbar. For information about creating a custom toolbar, click .

On the Tools menu, click Customize.
Show Me

If the toolbar that contains the button is not visible, click the
Toolbars tab, and then select the check box next to the toolbar name.


If the button you want to run the macro from is not on a toolbar, click
the Commands tab, and then click Macros in the Categories list. In the
Commands list, drag the Custom button onto a toolbar.


Right-click the toolbar button, and then click Assign Macro on the
shortcut menu.


In the Macro name box, enter the name of the macro.

-----------------------------------

use a macro like this

All I did was record the macro

Sub Format()
'
'
'

'
Selection.NumberFormat = "###,###"
End Sub
 
Yes copy the following code into a module, this is the macro code that you
will need to reference when you create a custom macro button.

Sub comma0()
With Selected
Cells.NumberFormat = "0,000"
End With
End Sub

Hope this helps
 
Thnx
I created a macro in a file(say 1.xls) & linked it to a button, works OK in
1.xls; If 1.xls is closed and i try to apply the style in another file (say
2.xls), 1.xls opens up, how can this be avoided?

rgds
 
Lots of people store these kinds of macros in a workbook named Personal.xls in
their XLStart folder. They use windows|Hide so that the workbook is hidden
while it's open.
 
Back
Top