'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Why Excel VBA Macros Do Not Work in SharePoint or Excel for the Web
Question details
The user is unable to run VBA macros when opening Excel workbooks through SharePoint browser views or Excel for the Web.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to execute VBA code, automate tasks, or use features like active-row highlighting while viewing or editing a spreadsheet in a web browser.
- Observed behavior
- The VBA macros do not run, and the browser-based version of Excel indicates that macros are unsupported.
Ensure you have a desktop spreadsheet application installed on your computer, as browser-based environments do not contain the runtime engine required to execute VBA code.
Open the Workbook in the Excel Desktop Application
The most effective way to use VBA macros stored in SharePoint is to launch the file directly in your local desktop application.
VBA (Visual Basic for Applications) relies on local system architecture and Windows-based components that web browsers cannot access. To use your automated scripts, the file must be routed from the web interface to the desktop client.
Navigate to your SharePoint document library and open the macro-enabled workbook (.xlsm) in Excel for the Web.
Look for the 'Viewing' or 'Editing' dropdown menu near the center or right side of the top ribbon.
Click on 'Open in Desktop App'. When prompted by your web browser, confirm that you want to open Microsoft Excel.
Once the file opens in the desktop application, click 'Enable Content' in the yellow security warning bar to allow your VBA macros to run normally.
Migrate VBA Macros to Office Scripts
If you need to automate workflows exclusively within the browser view, consider rewriting your VBA macros as Office Scripts.
Use WPS Office Desktop for Reliable Macro Execution
Since Excel for the Web does not support VBA macros, switching to a capable desktop suite is a practical solution. WPS Office is a lightweight, highly compatible alternative that natively handles standard Office files and allows you to run VBA macros efficiently on your local machine.
- 1. Download WPS Office: Visit the official WPS website and install the free WPS Office suite on your local computer.
- 2. Open your macro-enabled workbook: Launch WPS Spreadsheet and open your .xlsm file that contains the automated scripts.
- 3. Execute your macros: Enable macros when prompted and run your automated tasks seamlessly without browser limitations.
Frequently Asked Questions
Why do my macros work on my desktop but not in SharePoint?
SharePoint relies on Excel for the Web to display workbooks in your browser. This web-based environment lacks the necessary Windows-based VBA runtime engine required to execute macro code.
Will saving a macro-enabled workbook to SharePoint delete the macros?
No, uploading or editing an .xlsm file in SharePoint or Excel for the Web will not delete your existing VBA code. The macros simply remain dormant and will function normally once you open the workbook again in a compatible desktop app.
Why is the 'Open in Desktop App' button missing in SharePoint?
This usually happens if your organization's SharePoint administrator has restricted the ability to open files in local client applications, or if the device you are using does not have a recognized desktop Office suite installed.
