Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel programming vba - 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. |
excel programming vba - Macro button
Resolved · Low Priority · Version Standard
Reply Fri 13 Apr 2007, 16:29Delegate Monica said...
Monica has attended:
Excel Intermediate course
Excel Advanced course
Powerpoint Introduction course
Macro button
How can I insert macro button on excel spreadsheet?
For upcoming training course dates see: Pricing & availability
RE: macro button
Hi Monica,
Thank you for your question.
Create your Macro as per usual and give it a name.
Once this is done, go into view and toolbars, and down to Customise, once in there go to the tab that says Commands and choose Macros and drag the Custom Button with the smiley face on to your toolbar.
Once there (Customize window still open) right-click on the button and the last option is Assign Macro.
Good luck
Tracy
|