To enable Macros to run in EXCEL
- Click the File tab and then the Options button.
- Click Trust Center, then click Trust Center Settings.
- In the Trust Center, click Macro Settings.
- Make the selections that you want (enable Macros). Click OK.
This holds for future uses of this version of EXCEL on your PC unless you change the settings again.