ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Button with macro in toolbar (https://www.excelbanter.com/charts-charting-excel/155759-button-macro-toolbar.html)

Daniel

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

Jon Peltier

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





All times are GMT +1. The time now is 01:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com