IT Buddy Homepage

Free Computer Tutorials at IT Buddy

Lessons and Tutorials with Screenshots for Personal Computer Users - 2015 Home Tutorial Index

Free Computer Tutorials in screenshot style for Beginners at IT Buddy. How to do a wide variety of activities on a computer/laptop running Windows Vista and XP. A comprehensive selection of Computer Books and Manuals are also offered.



The Computer Shop for Software,
Computing and Office Products



Print Version

  How to Record a Macro in MS Word 2007 and MS Excel 2007
How to Select Text using the Keyboard.

Computer Books and Manuals
European Computer Driving Licence
Buying a Computer
MS Word
MS Excel
Windows 7
Windows Vista
Windows XP
Powerpoint 2003/2007
Dreamweaver CS4/3/MX
Web Design Publishing
Adobe Acrobat
Adobe CS4/CS3/CS2
Adobe Photoshop
Adobe Flash
Build Your Own PC
Digital Photograhy
Software from Amazon
at Best Prices
Internet Security & Child Protection

The same process is used for Word and Excel and Word 2007 is shown here.

In Microsoft Office Word 2007 and Excel 2007, you can automate frequently used tasks by
creating macros. A macro is a series of commands and instructions that you group together
as a single command to accomplish a task automatically.

Typical uses for macros are:

      1. To speed up routine editing and formatting
      2. To combine multiple commands — for example, to insert a table with a specific size and borders, and with a specific number of rows and columns
      3. To make an option in a dialog box more accessible
      4. To automate a complex series of tasks

    You can use the macro recorder to record a sequence of actions, or you can create a macro from scratch by entering code in the Visual Basic Editor (not covered in this tutorial). Note: To work with macros in Office Word 2007and Excel 2007, you need to show the Developer tab – as below.

    Click the Microsoft Office Button (1) , and then click Word Options (2).

    Click Popular (3).

    Under Top options for working with Word, select
    the Show Developer tab in the Ribbon check box (4)

Using  the Macro recorder.

On the Developer tab, in the Code group, click Record Macro (5 below).

" "

Note: If you give a new macro the same name as a built-in macro in Office Word 2007/Excel 2007, the new macro actions will replace the built-in macro. To view a list of built-in macros, on the Developer tab, in the Code group, click Macros. In the Macros in list, click Word Commands

In the Store macro in box, click  the template or document in which you want to store the macro.
    • In the Description box, type a description of the macro.

    " "

Do one of the following:

To begin recording the macro without assigning it to a button on the Quick Access Toolbar or to a shortcut key, click OK.

To assign the macro to the Quick Access Toolbar (6 above), do the following:

Click Button in Record Macro dialog box (above).
Under Customize Quick Access Toolbar, select the document (or all documents) for which you want to add the macro to the Quick Access Toolbar.
Under Choose commands from dialog box, click the macro that you are recording, and then click Add.
Click OK to begin recording the macro.

To assign the macro to a keyboard shortcut, do the following:

Click Keyboard in the Record Macro dialog box (above).
In the Commands box, click the macro that you are recording.
In the Press new shortcut key box, type the key sequence that you want, and then click Assign.
Click Close to begin recording the macro.
Perform the actions that you want to include in the macro.

Note: When you record a macro, you can use the mouse to click commands and options, but not to select text. You must use the keyboard to select text. For more information about selecting text by using the keyboard, see Selecting Text Using the Keyboard below.

To stop recording your actions:

Click Stop Recording in the Code group.

Note: macros can always be run in any document by clicking Macros in the Developer Tab.

Selecting Text Using the Keyboard

" "


copyright © 2008  All rights reserved