Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macro button
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Macro button
Resolved · Urgent Priority · Version Standard
Reply Tue 1 Apr 2008, 10:54Delegate Nick said...
Nick has attended:
Access Introduction course
Macro button
I have written several macros and I am using quick key's to run the macros, I would like to be able to use a button on the excel toolbar to run the macro instead. Can you please tell me how to add a button to a macro?
Cheers
NICK
For upcoming training course dates see: Pricing & availability
RE: Macro button
Hi Nick,
Go to Tools -> Customise -> Commands tab.
In the categories list box, scroll down and select Macros. Then, in the 'commands' box, click and drag the 'custom button' onto any toolbar you like, then release the mouse button.
Don't close down the 'customise' dialogue box just yet - it needs to remain open for the next step.
Right-click the new button and choose Assign Macro. Then follow the dialogue box instructions to select your Macro and other options.
You can also change the button's icon by right-clicking the button -> Change Button Image.
Repeat the above procedure for any additional buttons you want to create (eg. if you have more than one macro).
Then close the 'Customise' dialogue box.
This will now allow you to press the newly created button whenever you want to run the Macro.
I hope this answers your question.
Regards, Rich
Reply Tue 1 Apr 2008, 12:23Delegate Nick said...
RE: Macro button
Thanks for the prompt reply Rich - much appreciated!
|