Enabling Macros on Excel

1. Click on File then Options

2. Click on Trust Center then Trust Center Settings

3. First go Macro Settings on the left pane then under Macro Settings, you must Enable all macros

4. Click OK and OK again, then close and reopen. Macros should work.