Open Excel
Click File
Click Options
Click Trust Center
Click Trust Center Settings
Choose one of the following:
To enable macros globally: Click Macro Settings and select Enable VBA macros (or Enable macros)
To keep protection but allow signed macros: Select Disable all macros with notification or Enable VBA macros only for digitally signed macros
Click OK
Click OK again
If prompted when opening a file, click Enable Content (or Enable Macros) in the Security Warning banner
If the workbook is from a trusted source, add it to Trusted Locations:
In Trust Center Settings, click Trusted Locations
Click Add new location
Browse to the folder containing the workbook
Check the box to allow subfolders if needed
Click OK, then OK again