Editing a Macro

graphics/microsoft49.gif

Even if a macro works correctly, you may sometimes find that you want to change the way it runs or the steps it contains. To do so, you can edit the existing code ”the list of instructions Excel recorded when you turned on the macro recorder. As you recorded the macro steps, Excel kept track of each action in a separate location called a Module sheet. You can edit macro code by opening its Module sheet and using the keyboard to make changes just as you would to a word processing document. You can use the Delete and Backspace keys to remove characters and then type the corrections.

Edit a Macro

graphics/one_icon.jpg

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

graphics/tow_icon.jpg

Click the macro you want to edit.

graphics/three_icon.jpg

Click Edit.

graphics/foure_icon.jpg

Select the text to be edited, and then make the necessary corrections.

graphics/five_icon.jpg

When you're done, click the File menu, and then click Close And Return To Microsoft Office Excel.

graphics/11inf27.jpg

graphics/11inf28.jpg



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

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