Excel VBA Macro Runs in Desktop but Not in Excel Online: Fix

You have a VBA macro that works perfectly in the desktop version of Excel but fails or does nothing when you open the same workbook in Excel Online. This happens because Excel Online runs in a browser and does not support the full VBA engine that desktop Excel provides. This article explains why VBA macros are blocked in Excel Online and gives you the only reliable fix: converting your macro to Office Scripts or removing the macro entirely.

Why Excel Online Cannot Run VBA Macros

Excel Online is a web application built on JavaScript and HTML5. It does not include the Visual Basic for Applications runtime that desktop Excel installs. When you open a workbook that contains VBA code in Excel Online, the browser displays a warning banner: “This workbook contains macros. Macros are not supported in Excel for the web.” The VBA project is preserved in the file, but it cannot execute.

Microsoft designed Excel Online for collaboration, real-time co-authoring, and lightweight editing. VBA macros require full access to the Windows operating system, the file system, and external libraries. A browser cannot provide that level of access for security reasons. Even if you save the workbook to OneDrive or SharePoint, Excel Online will not run the VBA code.

What Happens When You Try to Run a Macro in Excel Online

No error message appears because the macro buttons and assigned keyboard shortcuts simply do nothing. The Developer tab is not available in Excel Online. You cannot open the Visual Basic Editor, view the VBA project, or step through code. The macro code remains in the file, but it is invisible and inactive.

Steps to Fix the VBA Macro Not Working in Excel Online

You have three options. The best long-term solution is to convert your VBA macro to an Office Script. Office Scripts run in Excel Online and are the official replacement for VBA in the browser.

1. Open the workbook in Excel Online and check the warning banner
   Go to the OneDrive or SharePoint site where the file is stored. Click the file to open it in Excel Online. Look at the top of the worksheet. If you see a yellow or gray banner that says “Macros are not supported in Excel for the web,” the macro is present but cannot run. Click “Edit in Desktop App” if you need to run the macro immediately.
2. Record a new Office Script in Excel Online
   Open the workbook in Excel Online. Go to the Automate tab. Click “New Script.” The Code Editor opens on the right side of the screen. Click “Record” to start capturing your actions. Perform the steps that your VBA macro would do. Click “Stop Recording.” The script is saved as a TypeScript file inside the workbook. Name the script and test it by clicking “Run.”
3. Manually translate VBA code to Office Scripts
   If your VBA macro is complex, you must rewrite it manually. Open the VBA code in desktop Excel. Identify each operation: selecting ranges, copying data, applying formulas, sorting tables, or creating charts. Write the equivalent TypeScript code in the Office Scripts Code Editor. For example, VBA’s Range("A1").Value = 5 becomes workbook.getWorksheet("Sheet1").getRange("A1").setValue(5). Use the Office Scripts API reference documentation from Microsoft to match each method.
4. Assign the script to a button in Excel Online
   After the script is created and tested, you can add a button to the worksheet. Click the Automate tab. Click “All Scripts.” Find your script. Click the three dots menu next to the script name and select “Add to worksheet.” A button appears on the sheet. Any user with edit permissions can click the button to run the script in Excel Online.
5. Use Power Automate to trigger the script from a cloud flow
   If you need to run the script automatically, create a Power Automate flow. Go to make.powerautomate.com. Create a new scheduled flow or an instant flow. Add the action “Run script” from the Excel Online (Business) connector. Select the workbook and the script. The flow can run on a timer, when a file is modified, or when a form is submitted. This replaces VBA’s Application.OnTime or worksheet event triggers.

If You Must Keep the VBA Macro for Desktop Users

You can keep the VBA macro in the file for desktop users while providing an Office Script for online users. The workbook will store both the VBA project and the script file separately. Desktop users see the Developer tab and can run the macro. Online users see the Automate tab and can run the script. No conflict occurs because Excel Online ignores the VBA project entirely.

Common Issues After Converting to Office Scripts

Office Scripts Are Not Available in My Tenant

Office Scripts require a Microsoft 365 subscription that includes the desktop version of Excel. Business Standard, Business Premium, Enterprise E3, and Enterprise E5 all include Office Scripts. If you have a Microsoft 365 Basic or Family plan, Office Scripts are not available. In that case, you cannot automate tasks in Excel Online. You must edit the workbook in the desktop app.

My VBA Macro Uses Windows API Calls or External Libraries

Office Scripts cannot call Windows API functions, ActiveX controls, or COM objects. If your macro interacts with the file system, sends emails via Outlook, or controls other applications, that functionality is lost in Excel Online. You must either replace that behavior with Power Automate actions or run the macro only in desktop Excel.

The Office Script Does Not Work on All Worksheets

Office Scripts must reference specific worksheet names. If your workbook has multiple sheets and the user renames a sheet, the script fails. Use the getWorksheet() method with the sheet name as a string. For dynamic access, loop through all worksheets using workbook.getWorksheets() and check the getName() property.

VBA Macro vs Office Script: Key Differences

Item	VBA Macro (Desktop)	Office Script (Excel Online)
Language	Visual Basic for Applications	TypeScript (JavaScript superset)
Runtime location	Windows desktop application	Browser (Microsoft cloud)
File access	Full file system, external DLLs, COM objects	Only the current workbook via API
User interface	UserForms, ActiveX controls, message boxes	No custom UI; uses buttons or Power Automate
Trigger methods	Worksheet events, Application.OnTime, buttons	Script buttons, Power Automate flows, scheduled runs
Security model	Macro-enabled file (.xlsm) with digital signatures	Script stored inside .xlsx file; no macro warning

You can now identify why your VBA macro fails in Excel Online and apply the correct fix. The primary solution is to convert your macro to an Office Script using the Automate tab. If Office Scripts are not available in your subscription, edit the workbook in the desktop app whenever you need to run the macro. For advanced automation, combine Office Scripts with Power Automate to trigger actions from cloud events. Use the workbook.getWorksheet() method in your script to avoid errors when worksheet names change.