How to create a macro in Excel 2003?

How to create a macro in Excel 2003?

Rating:

The steps are as follows:

1. From the Tools menu, choose Macro, and then Record New Macro.





2. In the Macro Name text box, enter the name for the macro. The name of the macro must start with a letter and must not contain any spaces. If You want to create a short cut for running macro, type a letter in the Shortcut Key box. In the Store Macro In drop-down list, select the location in which to store the macro. If you want to macro to be available each time you use excel, select Personal Macro Workbook. If you want the macro to be available for a new workbook, select New Workbook. In the Description text box, type a description, if required. Click OK.





3. If the macro is to run relative to the position of the active cell (selected cell),click Relative Reference on the Stop Recording toolbar. Perform the steps involved in the procedure to record the macro. To stop recording, go to the Tools menu, choose Macro, and then Stop Recording.





4. To run a macro, go to Tools menu, choose Macro and then Macros. A box named Macro will open. Select the required macro to be run from the Macro Name section, and then click Run.

Rating: