How to Write Macros in Excel 2003

1. Click 'Tools > Macros > Record New Macro...' in the top menu.
2. Choose a name for your macro and type it into the 'Macro Name' textbox. For example, if you want to create a button that sets a certain cell to a special format, you might name the macro 'Special Format Macro.'
3. Type the shortcut key you want to use to access the macro into the 'Shortcut Key' textbox. If the example, you might choose 'S' as your shortcut key.
4. Press 'OK.'
5. Make the changes you wish to record into the macro. For example, you could make the text of the cell bold and the borders green.
6. Press the stop button on the Stop Recording Dialog. The button has a blue square on it.