Because of the way macros are stored, they often are included as part of a workbook created in Excel. This does not usually present a problem when workbooks are not exchanged, i.e., when a user never opens a workbook someone else has worked on. This is now rarely the case, since users are constantly exchanging computer files. Because the user has not maintained exclusive control over exchanged workbooks, someone else could have inserted malicious macro code into the workbooks (either deliberately or inadvertently). Such malicious code is similar to computer viruses we have all sadly become familiar with; in fact they are known as "macro viruses." To establish some protection against macro viruses, Excel provides macro security features.
Macro security can be confusing because it is set up to take effect when you open a workbook. If you create a new workbook and record a macro, you will be able to run the macro regardless of the security settings. However, once you close the workbook and reopen it macro security will be in effect, as discussed below.
To set the macro security level (and to work with the VBA editor) in version 2007/2010, you will need to include the Developer tab on the ribbon if it is not already there. To do so, in version 7 click on the Office button, then Excel Options/Popular/Top Options for Working with Excel/Show Developer Tab in Ribbon. In version 2010, click on File/Options/Customize Ribbon. Under Customize the Ribbon select Main Tabs, then check the box next to Developer. Click OK, and the Developer tab will appear on the ribbon.
On the Developer tab, in the Code group, click on Macro Security. I recommend the option "Disable All Macros with Notification." With that setting, when you open a workbook containing potentially dangerous macros you will be prompted whether to allow the macros in the workbook to be run or not.