How to Set Excel Macro Security to Medium

1. Open Microsoft Excel. Go to Start–Programs–Microsoft Office–Microsoft Office Excel. Please note that in some versions of Microsoft Office, you will Microsoft Office Excel straight from Programs.
2. Go to the Tools menu at the top of your Excel window.
3. Open the Tools menu and go to Macros.
4. Choose Security from the Macros menu.
5. Choose Medium from the Security Level tab. You also have the options of Very High, High, and Low. For most users High or Medium is best.
6. Click the OK button and restart Excel by closing the program and re-opening it. Your macro security level is now set to medium.