Set the security level to Medium or Low.
Notes
The first character of the macro name must be a letter. Other characters can be letters, numbers, or underscore characters. Spaces are not allowed in a macro name; an underscore character works well as a word separator.
Do not use a macro name that is also a cell reference or you can get an error message that the macro name is not valid.
Note The shortcut key will override any equivalent default Microsoft Excel shortcut keys while the workbook that contains the macro is open.
If you want a macro to be available whenever you use Excel, select Personal Macro Workbook.
If you want to include a description of the macro, type it in the Description box.
If you want the macro to run relative to the position of the active cell, record it using relative cell references. On the Stop Recording toolbar, click Relative Reference so that it is selected. Excel will continue to record macros with relative references until you quit Excel or until you click Relative Reference again, so that it is not selected.
Create a macro using Microsoft Visual Basic
Automatic macros, such as Auto_Activate, are designed to run when you start Microsoft Excel. For more information about these macros, see Visual Basic Help.
Copy part of a macro to create another macro
To copy the entire macro, make sure to include the Sub and End Sub lines in the selection.
You can view your Personal Macro Workbook file (Personal.xls) at any time by opening it in the Visual Basic Editor (Alt+F11). Because Personal.xls is a hidden workbook that is always open, you must unhide it if you want to copy a macro.