VBA & Macro Problems

Use VBA Macros in Microsoft 365 Excel Desktop

Ayan MasoodAyan Masood Nov 14, 2026 868 views

Question details

The user wants to know which versions of Excel support VBA and macros and whether Microsoft 365 desktop apps can replace or coexist with Office 2016 or 2019.

Use VBA Macros in Microsoft 365 Excel Desktop
Product
Microsoft 365 Excel
Device & OS
not provided
Scenario
The user relies on VBA procedures and needs an Excel version with a Visual Basic Editor and macro support.
Observed behavior
Excel for the web and mobile apps do not provide the Visual Basic Editor or run VBA macros; Excel desktop on Windows and Mac supports VBA.
Before you start

Check that your Microsoft 365 subscription includes desktop apps and identify any existing Office installation and its bit version. If you need to keep Office 2016 or 2019, check Microsoft's installation compatibility guidance before installing Microsoft 365.

Solution 1Recommended

Install Excel Desktop to Use VBA Macros

Use the Windows or Mac desktop app when you need to edit or run VBA code.

1
Check your subscription

Sign in to your Microsoft account and check Subscriptions to confirm that your plan includes the Microsoft 365 desktop apps.

2
Install the desktop apps

Sign in at microsoft365.com, select Install apps, and follow the installer instructions for Windows or Mac.

3
Open the workbook in Excel

Launch the installed Excel app and use File > Open to open your macro-enabled workbook.

4
Access VBA and macros

Use the Developer tab to open Visual Basic or view Macros. If Developer is hidden, enable it in Excel's ribbon customization settings.

5
Run a trusted macro

In Developer > Macros, select a macro and choose Run. If Excel displays a security warning, enable content only when you trust the file and its source.

Install Excel Desktop to Use VBA Macros
Check existing Office installations: Microsoft 365 may not install alongside every Office 2016 or 2019 configuration. Installation technology and 32-bit or 64-bit versions can affect compatibility.
Free Microsoft Office alternative

Work with Spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office file compatibility, making it easy to move everyday spreadsheet work. It does not add VBA support to Excel for the web or mobile; check VBA availability and macro compatibility in your WPS edition before relying on it.

Open and edit common spreadsheet files in a familiar interfaceCompatible with Microsoft Excel formats including XLSX and XLSMove everyday spreadsheet work from Microsoft Office with minimal adjustmentFree and lightweight for common document and spreadsheet tasks
microsoft office alternative - wps office

Frequently Asked Questions

Can Excel for the web run VBA macros?

No. Open the workbook in the Excel desktop app on Windows or Mac to run VBA macros or use the Visual Basic Editor.

Does Microsoft 365 include desktop Excel?

Many Microsoft 365 plans include desktop apps, but not all do. Check Subscriptions in your Microsoft account before using the Install apps option at microsoft365.com.

How do I show the Developer tab in Excel?

Open Excel's ribbon customization settings and enable Developer. On Windows, go to File > Options > Customize Ribbon; on Mac, check Excel's ribbon and toolbar preferences.

Can I keep Office 2016 or 2019 installed with Microsoft 365?

It depends on the installation technology and bit versions of the Office products. Check Microsoft's compatibility guidance for your specific installations before proceeding.

Will a Windows Excel macro work on a Mac?

Excel for Mac supports VBA, but macros that depend on Windows-specific components or file paths may need changes. Open the workbook in Mac desktop Excel and test the procedures you need.