Enable VBA Macros and Find the Trust Center in Excel 365
Question details
The user wants to enable VBA macros in Excel 365 and locate the relevant security settings.

- Product
- Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- The user wants to run VBA macros but sees only a limited set of Excel options or cannot find the Trust Center.
- Observed behavior
- VBA is unavailable in Excel for the web, and an organization policy may restrict desktop macro settings.
Check whether the workbook is open in a browser or the desktop Excel app, and identify whether you are using Windows or Mac. Only enable macros from sources you trust.
Find macro settings in desktop Excel for Windows
Use the Trust Center to choose how desktop Excel handles VBA macros.
If the workbook is open in Excel for the web, select Open in Desktop App, then open it in Excel for Windows.
Select File > Options > Trust Center > Trust Center Settings.
Select Macro Settings and choose the appropriate option. Disabling VBA macros with notification lets you decide whether to enable trusted macros when prompted.
Select OK to close the Trust Center and Excel Options. Reopen the workbook if needed and use the security notification to enable macros only when you trust the file.

Set macro security in Excel for Mac
Use Excel's Mac security preferences instead of the Windows Trust Center.
Make trusted personal macros available in desktop Excel
Save macros to the Personal Macro Workbook or use an approved trusted location when appropriate.
Work with spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Office files, making it easy to migrate everyday spreadsheet work. It does not change Excel's Trust Center or organization policies.

Frequently Asked Questions
Can I run VBA macros in Excel for the web?
No. Open the workbook in the desktop Excel app for Windows or Mac to work with VBA macros.
Where is the Trust Center in Excel 365 for Windows?
In desktop Excel, select File > Options > Trust Center > Trust Center Settings. Select Macro Settings to review VBA security options.
Where are macro settings in Excel for Mac?
In desktop Excel, select Excel > Preferences or Settings > Security & Privacy, then review the Macro Security options.
Why can't I change Excel's macro settings?
Your organization may control macro security through policy. If the settings are locked or unavailable in desktop Excel, contact your administrator.
How can I make my macros available across workbooks?
In desktop Excel, select View > Macros > Record Macro and choose Personal Macro Workbook under Store macro in. Save the Personal Macro Workbook when prompted.




