![]() |
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 |
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