Use VBA Macros in Microsoft 365 Excel Desktop
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.

- 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.
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.
Install Excel Desktop to Use VBA Macros
Use the Windows or Mac desktop app when you need to edit or run VBA code.
Sign in to your Microsoft account and check Subscriptions to confirm that your plan includes the Microsoft 365 desktop apps.
Sign in at microsoft365.com, select Install apps, and follow the installer instructions for Windows or Mac.
Launch the installed Excel app and use File > Open to open your macro-enabled workbook.
Use the Developer tab to open Visual Basic or view Macros. If Developer is hidden, enable it in Excel's ribbon customization settings.
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.

Move a Workbook from Excel for the Web to Desktop
Use this approach when a workbook is open online but you need to work with its VBA macros.
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.

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.




