1. Click on File then Options
2. Click on Trust Center then Trust Center Settings
3. First go Macro Settings on the left pane
4. Under Macro Settings, Enable VBA Macros
5. Next, Go to ActiveX Settings on the left pane
6. Under ActiveX Settings for all Office Applications, you must Enable all controls without restrictions and without prompting
7. Click OK and OK again, then close and reopen. Macros should work.