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: http://www.youtube.com/watch?v=Ycab4OiPug0

A good tutorial for creating macros in Excel 2003: http://computerwhizzard.50megs.com/excelminitutorial.html

A more complex, but good explanation of macros in Excel 2003: http://www.excel-vba.com/vba-7-excel-macro-recorder.htm

A tutorial for creating macros in Excel 2007: http://www.tutorialized.com/view/tutorial/Macros-%7BTutorial-for-beginners%7D/27280