Enable macros just for the current session
- Click the File tab.
- In the Security Warning area, click Enable Content.
- Select Advanced Options.
- In the Microsoft Office Security Options dialog box, click Enable content for this session for each macro.
- Click OK.
How do I enable macros in an Excel workbook?
Click the File tab, and then click Options at the very bottom of the left bar. On the left-side pane, select Trust Center, and then click Trust Center Settings… . In the Trust Center dialog box, click Macro Settings on the left, select Enable all macros and click OK.
How do I enable macros in Excel for Mac?
Enable or disable macros in Office for Mac
- Click the Word, Excel, or PowerPoint menu as appropriate.
- Click Preferences.
- Click Security & Privacy. To allow all macros to run select the Enable all macros radio button. Caution: This will allow ALL macros, both good and bad, to run without any further warning.
