Button with macro in toolbar

G

Guest

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
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top