Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

macros

ResolvedVersion 2003

Vanessa has attended:
Upgrade to Office 2007 course

Macros

When would you use macros and what are they for?

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

 

Training courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Microsoft Office tip:

Full Menu Display (Office 2003-2000)

One of the developments in Microsoft Office is that the Menu system has been optimized. This means that only recently used functions are displayed initially when you SINGLE CLICK on the menu.
There are many ways of getting around this:
1. DOUBLE CLICK on the menu bar, it will automatically expand
2. click on the DOUBLE ARROW you see on the bottom of the menu.
3. Wait for the menu to expand

If you always want to have the menus expanded:
4. On the menu bar, click TOOLS, then CUSTOMISE. Select OPTIONS, then uncheck the

View all Microsoft Office hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.19 secs.