How to Do Macros in Excel 2003

1. Open up the Excel 2003 file in which you want to create a macro. Select the 'Tools' menu at the top of the screen, then move your mouse to the 'Macro' option and select 'Security' from the pop-up menu. Select either medium or low in order for macros to operate correctly in the worksheet. Low will always prompt you if you want to run the macro, while medium will not. Click 'OK' to continue.
2. Click on the cell where you want the macro to start. You will be given the option later to use relative references, and if you are then you will need to have selected the starting macro location beforehand.
3. Click on the 'Tools' menu again and move your mouse over 'Macro.' Choose 'Record New Macro' from the list of options. A small record macro window will appear.
4. Enter in the name of your macro into the 'Name' field. The name must begin with a letter and cannot be a cell reference, like 'A1' or 'Z12.' Type in a shortcut key in the required field so that Excel will run the macro when you press the key. This key must be a letter, and is case-sensitive. If you want this macro to be available on every workbook, change the 'Store macro in' box to read 'Personal Macro Workbook.' Finally, type in a description of the macro, so that you will remember what it does. Click 'OK' when you are done.
5. Decide whether you will be using relative references in your macro. When you use relative references, any movement around the spreadsheet will be relative to whatever cell is selected when you run the macro. For example, if you are starting at cell A1 and you select cell A2 in the macro, if you are using relative references, Excel will simply select the cell below the selected cell when someone runs the macro. Without relative references, the macro will always select cell A2 regardless of what cell the user has selected. Relative references are set 'off' be default, so if you want to turn them on, click on the small button to the right of the square 'Stop' button in the macro window. Relative references will stay on until you click the button again to turn them off.
6. Perform the macro actions on your spreadsheet. The macro will record every move that you make. Click the square 'Stop' button when you are done making the macro.
7. Hold 'Ctrl' and press the letter key you assigned to the macro when you want to run it.