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 » Macro
Macro
Resolved · Medium Priority · Version 2007
Helen has attended:
Excel Advanced course
Access Advanced course
Macro
step through recording a macro
RE: Macro
Hello Helen
Thank you for your question and welcome to the forum.
To create a macro, you need to have the Developer ribbon showing in Excel 2007.
If the Developer ribbon is not showing, then:
1. Click the Office button (top left corner) then select Excel Options.
2. Under the Popular category, tick the checkbox for Show Developer tab in the Ribbon, and exit Excel Options.
To create a macro:
1. Go to the Developer tab, and in the Code group, select Record Macro.
2. In the Macro name box, enter a name for the macro.
3. Assign a shortcut key if you like.
4. In the Store macro in list, select the workbook in which you want to store the macro.
5. Include a description of what the macro does, if you like.
6. Click OK to start recording the steps/actions you perform next.
7. When you have finished recording your macro, go to Developer tab, and in the Code group, click Stop Recording.
I hope this helps.
Amanda
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:Jumping Between Sheets in a BookPgDn and PgUp keys scrolls up and down a screen page in most applications. |