Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Button with macro in toolbar
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Button with macro in toolbar
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lost new custom toolbar button with its macro | Excel Discussion (Misc queries) | |||
Command Button for Macro on a Toolbar | Excel Discussion (Misc queries) | |||
Command Button for Macro on the Toolbar | New Users to Excel | |||
Macro button on toolbar | Excel Discussion (Misc queries) | |||
assigning macro to toolbar button | Excel Worksheet Functions |