How to Record a Macro in MS Word and Excel 2007 - Select Text Using Keyboard at IT Buddy

Free Computer Tutorials at IT Buddy.
Tutorials for beginners with screenshots.

http://www.itbuddy.org - 2012	Home	Tutorial Index	Sitemap	Contact	Links

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

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

Computer Books and Manuals
Categories

ECDL
European Computer Driving Licence

Buying a Computer

Powerpoint 2003/2007

Dreamweaver CS4/3/MX

Web Design Publishing

Adobe CS4/CS3/CS2

Adobe Photoshop

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:

To speed up routine editing and formatting
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
To make an option in a dialog box more accessible
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 itbuddy.org All rights reserved