Forum home » Delegate support and help forum » Microsoft Office general help » Macros
|
|
|
The UK's most regular Training information: |
|
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. |
Macros
Resolved · Low Priority · Version 2003
Reply Wed 17 Sep 2008, 16:50Delegate Vanessa said...
Vanessa has attended:
Upgrade to Office 2007 course
Macros
When would you use macros and what are they for?
For upcoming training course dates see: Pricing & availability
RE: macros
Hello Vanessa
Thank you for your question and welcome to the forum.
A macro is usually created when someone wants to automate a task that they perform routinely in an application, which involves them going through several steps to complete the task.
For example, you might create a macro in Word that inserts a picture, puts it in a certain position and make it a certain size.
In Office 2003, most applications will have the ability to record a macro by going to the Tools menu, selecting Macro and Record New Macro.
Once you have entered a name etc for your macro then you go through the steps you would normally go through the complete the task, then go to Tools - Macro and select Stop Recording.
To run the macro, go to Tools - Macro - Macros, select your macro and click Run.
In Office 2007, you need to have the Developer ribbon showing to record macros in Word and Excel. You can do this by going to the Office button, then Word/Excel Options and ticking the Show the Developer Ribbon option in the Popular category.
I hope this helps.
Amanda
|