eHow launches Android app: Get the best of eHow on the go.

How To

How to Record a Macro in Excel 2003

Contributor
By eHow Contributing Writer
(0 Ratings)

Macros are mini programs that help you quickly do tasks in Excel. If you can perform a series of actions in Excel, you can create a macro for that series of tasks and use it as a shortcut. Learn how to record a macro in Excel 2003.

Difficulty: Moderate
Instructions

Things You'll Need:

  • Computer with Excel 2003
  1. Step 1

    Open Excel. Either open the program itself or open an existing file.

  2. Step 2

    Set your security level. Go to "Tools > Options." Go to the Security tab and click on "Macro Security." Go to the Security Level tab and change the level to medium or low.

  3. Step 3

    Go to "Tools > Macro." Choose "Record New Macro" from the options.

  4. Step 4

    Type a name into the macro name box.

  5. Step 5

    Type the location of the macro into the box labeled "Store Macros In." Click “OK."

  6. Step 6

    You are ready to begin recording your macro. Perform the series of tasks you would like to create the macro for.

  7. Step 7

    When you are finished, click "Stop Recording" on the toolbar. You may make as many macros as you need.

Tips & Warnings
  • A Shortcut Key identifies how you'd like to trigger your macro to run. If you enter the letter "K" into the Shortcut Key box when creating your macro, then when you are ready for the macro to run, hit "Ctrl" and "K" and the macro will start.
  • If you make a mistake while recording the macro, just fix it as you normally would.
  • Remember to save your work after recording a macro.
Subscribe

Post a Comment

Post a Comment

Related Ads

  • Have you done this? Click here to let us know.
I Did This
Get Free Computers Newsletters

Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy.   en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License.

eHow Computers
eHow_eHow Technology and Electronics