How do I enable macros in Excel 2003?
- Start Excel
- Click the Tools menu, click Macros, and click Security. The following window will be displayed. Excel's default security level is set to "High"
- Click Medium (show me)
- Click OK
- Open your workbook
- When the Security Warning window displays, click Enable Macros to allow macros in your workbook to run (show me)
- Trusted Publishers - When the Security Warning window displays, if the workbook you are opening contains macros that are digitally signed you will see a checkbox entitled "Always trust macros from this publisher" (as shown above). Checking this box will enable macros for all other workbooks signed by the publisher without displaying the Security Warning window. Many prebuilt templates from Event 1 Software contain macros with Event 1 Software's digital signature. Making Event 1 Software a trusted publisher will allow you to more easily enjoy the functionality of these templates.
- High Security - If you only plan to use workbooks that contain digitally signed macros, you can leave your macro security level set at "High". This setting disables all macros except for those that are digitally signed by a trusted publisher. The first time you open a workbook containing macros that are digitally signed by the publisher; you can check the box entitled "Always trust macros from this publisher" (as shown above) to automatically enable macros from the publisher in the future.
- Low Security - Event 1 Software does not recommend that you set your macro security level to "Low". Doing this enables all macros to run in any workbook that you open. This is potentially dangerous if you open a workbook that contains a virus (in the form of a macro built for malicious purposes).