Right click somewhere on the toolbar, but not right on a button, and choose
Customize. Click on the Commands tab, scroll down to Macros in the listbox
on the left, select Custom Button on the right and drag it where you want it
on the toolbar. Right click on the button, choose Assign Macro, and select
the macro from the list. Right click on the button and use the commands on
the pop up menu to make changes to the button.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Daniel" wrote in message
...
How can I create a button in toolbar and assign a macro to this button?

What I need is hitting the button and automatically refresh data and
update
my charts.
Thanks
Daniel