To change macro settings to allow you to run XLM macros, do the following: Click the File tab, and then click Options. Click Trust Center, and then click Trust Center Settings. Click Macro Settings, and then select the Enable Excel 4.0 macros when VBA macros are enabled check box. You can then select Disable VBA macros with notification or ...