VBA & Macro Problems

Fix Excel Macros and ActiveX Controls in SharePoint Online

Khadija KhanKhadija Khan Nov 20, 2026 868 views

Question details

The user needs to use a SharePoint Online workbook containing VBA macros, form controls, and ActiveX drop-down controls.

Excel Macros and ActiveX Controls Do Not Work in SharePoint Online
Product
Excel for the web and SharePoint Online
Device & OS
not provided
Scenario
A workbook that works in desktop Excel is uploaded to SharePoint Online for use in a browser.
Observed behavior
The VBA macros and controls do not function in Excel for the web.
Before you start

Check that you have permission to open the SharePoint workbook and access to a desktop version of Excel. Identify which drop-downs and actions depend on VBA, form controls, or ActiveX before deciding whether to use the desktop app or redesign the workbook.

Solution 1Recommended

Open the SharePoint workbook in desktop Excel

Use desktop Excel when you need the existing VBA macros and controls rather than a browser-based replacement.

1
Locate the workbook

Open the SharePoint document library in your browser and select the workbook.

2
Open in the desktop app

Choose Open > Open in app, or use the workbook's menu to select Open in desktop app.

3
Check security prompts

If Excel displays a security warning, review it and follow your organization's policy before enabling macros or controls. Only enable content from a source you trust.

4
Test the workbook

Use the workbook's drop-down controls and run a macro from its button or Developer > Macros to confirm that the required features work.

Open the SharePoint workbook in desktop Excel
Desktop security settings still apply: ActiveX controls may be disabled by default or by organizational policy in desktop Excel. Opening the file in the app does not guarantee that macros or controls will be permitted.
Free Microsoft Office alternative

Work with Excel files in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Excel formats, making it easy to move everyday spreadsheet work. It does not fix Excel for the web's VBA or ActiveX limitations.

Edit spreadsheets in a familiar, easy-to-use interfaceOpen and work with Microsoft Excel XLSX and XLS filesUse spreadsheet features such as data-validation lists for suitable drop-down workflowsMove everyday document and spreadsheet work to a lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Can Excel for the web run VBA macros?

No. Excel for the web cannot run VBA macros. Open the workbook using Open > Open in app to use VBA in desktop Excel, subject to its security settings.

Why does my ActiveX drop-down not work in the browser?

Excel for the web does not support ActiveX controls as desktop Excel does. Open the workbook in desktop Excel or replace the control with a suitable browser-compatible feature, such as a data-validation list.

Will opening the workbook in desktop Excel always enable ActiveX?

No. ActiveX controls and macros can be blocked by Excel security settings or organizational policy. Review any security warning and follow your organization's guidance.

Can I convert a VBA macro directly to an Office Script?

Office Scripts do not automatically convert VBA. If the Automate tab is available in Excel for the web, you can assess the existing macro and rewrite suitable tasks as scripts.

Is there a scheduled fix for VBA and ActiveX in Excel for the web?

No scheduled fix is established in this record. Check Microsoft's official Excel and Microsoft 365 announcements for current feature plans.