98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Macros
Macros
Resolved · Low Priority · Version 2003
Andrew has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Access Advanced course
Macros
How do you run a macro
RE: Macros
Hi Andrew,
Welcome to the forum and thank you for your post; in answer;
Once you have created your macro you have a number of ways that it can be run;
1. Tools>Macro>Macros choose the macro and click Run
2. From a button created on the Toolbar' Right Click on the toolbars and from the menu choose Customize, click the Commands Tab and scroll until you see Macros, from the Commands Pane drag the Custom Macro button and deposit it on the toolbar, you can now assign a macro to this button, change its presentation (face image etc) at this point.
3. From a button created on your worksheet, Open the View>Toolbars>Forms toolbar and click on the Command Button then drag to create a rectangle on the worksheet, immediatly you will be presented with the Assign Macro dialog box, you can now assign your chosen macro to the button, make any editing changes at this point. Note: if you wish to edit the button in the future you must right-click on it and then choose from the menu.
I hope that has helped, regards Pete
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 tip:Bracketed negative numbersOften Excel users wish to display negative numbers in colour red and bracketed |