Automating Your Work with Macros

Do you often redo many tasks that require the same, sometimes lengthy, series of steps? Rather than repeat the same actions, you can work faster by recording the entire series of keystrokes and commands in a custom command, or macro . A macro is a sequence of commands and entries that can be activated collectively by clicking a toolbar button, clicking a menu command, typing a key combination, or clicking the Run command in the Macros dialog box. Macros are a perfect way to speed up routine formatting, combine multiple commands, and automate complex tasks. The macro recorder archives every mouse click and keystroke you make until you stop the recorder. Any time you want to repeat that series of actions, you "play," or run, the macro.

Record a Macro

graphics/one_icon.jpg

Click the Tools menu, point to Macro, and then click Record New Macro.

graphics/two_icon.jpg Enter a macro name .

Macro names must start with a letter and can be as many as 80 letters and numbers . Macro names cannot contain spaces, periods, or other punctuation.

graphics/three_icon.jpg

Assign a toolbar button or keyboard shortcut key to the macro.

graphics/four_icon.jpg

Select where you want to store the macro.

graphics/five_icon.jpg

Enter a detailed description of the macro.

graphics/six_icon.jpg

Click OK.

graphics/seven_icon.jpg Perform each command or action to complete the task.

The macro recorder doesn't record mouse movements within a document. For example, you cannot use the mouse to select, copy, or move objects. Instead, you must use keystrokes.

graphics/eight_icon.jpg

Click the Stop Recording button on the Stop Recording toolbar.

graphics/02inf39.jpg

graphics/02inf40.jpg

Run a Macro

graphics/one_icon.jpg

Click the Tools menu, point to Macro, and then click Macros.

graphics/two_icon.jpg

If necessary, click the Macros In list arrow, and then click the document that contains the macro you want to run.

graphics/three_icon.jpg

Click the name of the macro you want to run.

graphics/four_icon.jpg

Click Run.

graphics/02inf41.jpg

Delete a Macro

graphics/one_icon.jpg

Click the Tools menu, point to Macro, and then click Macros.

graphics/two_icon.jpg

Select the macro you want to remove.

graphics/three_icon.jpg

Click Delete, and then click Yes to confirm the deletion, and close the dialog box.

graphics/02inf42.jpg

Did You Know?

There is an appropriate location to store macros . If you want a macro to be available in all your Word documents, store it in the Normal template. If you want a macro available in all your worksheets, store it in the Personal Workbook.



Show Me. Microsoft Office 2003
Show Me Microsoft Office 2003
ISBN: 0789730073
EAN: 2147483647
Year: 2002
Pages: 418

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net