Help with Macros

A macro allows you to repeat keystrokes without having to retype them. For example, you could set up a macro in Excel to format a heading. Then, whenever you wanted to format cells that way, just highlight the cells and run the macro. The steps for creating such a macro in Excel 2003 are as follows:

Excel's security must be set to "Medium" for macros to be recorded. Security level is set at Tools/Macros/Security. Whenever you open a workbook, you will still be prompted to enable the macro, because it fears that the macro is malicious code, since it is a program within Excel. Here is a great video that shows you how to create a macro and add a button to run them:

A good tutorial for creating macros in Excel 2003:

A more complex, but good explanation of macros in Excel 2003:

A tutorial for creating macros in Excel 2007: