Use the following procedure for Excel 2003.
-
In Excel, on the menu bar, select Tools > Options.
-
On the Security tab, select Macro Security.
-
On the Security Level tab, select Medium.
-
Select OK to close the Security dialog.
-
Select OK to close the Options dialog.
Use the following procedure for Excel 2007 and Excel 2010:
-
In Excel, select the Office button.
-
Select the Excel Options button.
-
Select Trust Center > Trust Center Settings > Macro Settings.
-
Select the Disable all macros with notification option.
-
Select OK.