VBA & Macro Problems

Enable VBA Macros and Find the Trust Center in Excel 365

Muhammad TalhaMuhammad Talha Nov 18, 2026 870 views

Question details

The user wants to enable VBA macros in Excel 365 and locate the relevant security settings.

Enable VBA Macros and Find the Trust Center in Excel 365
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.
Before you start

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.

Solution 1Recommended

Find macro settings in desktop Excel for Windows

Use the Trust Center to choose how desktop Excel handles VBA macros.

1
Open the desktop app

If the workbook is open in Excel for the web, select Open in Desktop App, then open it in Excel for Windows.

2
Open the Trust Center

Select File > Options > Trust Center > Trust Center Settings.

3
Choose a macro setting

Select Macro Settings and choose the appropriate option. Disabling VBA macros with notification lets you decide whether to enable trusted macros when prompted.

4
Apply your choice

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.

Find macro settings in desktop Excel for Windows
Settings may be managed: If the Trust Center or macro settings are unavailable or locked, your organization may control them through Group Policy. Contact your administrator.
Free Microsoft Office alternative

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.

Open and edit spreadsheet data with familiar tools.Compatible with Microsoft Excel formats such as XLSX and XLS.Use a lightweight office suite for everyday document work.Move between common Office file formats with a familiar interface.
microsoft office alternative - wps office

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.