How to Fix Excel Scripts and Buttons Not Working for Shared Users
Question details
Users need to resolve an issue where Excel scripts and worksheet buttons function correctly for the file owner but are unavailable or unresponsive for shared users with edit permissions.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Collaborating on a shared Microsoft 365 Excel workbook that contains custom Office Scripts or VBA macro buttons.
- Observed behavior
- Shared users with edit access cannot run the scripts or click the buttons; the features appear unavailable or trigger an error when clicked.
Verify that all users attempting to run the scripts have edit permissions for the shared workbook, and check whether they are accessing the file via Excel for the Web or the desktop application.
Open the Workbook in Desktop Excel (For VBA Macros)
Excel for the Web does not support VBA macros. Users must use the desktop version to interact with macro-enabled buttons.
If your worksheet buttons are tied to traditional VBA macros, they will inherently fail to run in the web version of Excel. Microsoft currently restricts VBA macro execution to the desktop application.
Navigate to the shared Excel file in your web browser and click to open it in Excel for the Web.
Click the 'Editing' or 'Viewing' dropdown on the top ribbon menu, and select 'Open in Desktop App'.
Once the file opens in the desktop application, click 'Enable Content' in the yellow security warning bar at the top to allow VBA macros and buttons to run.
Verify Permissions and Share Office Scripts
Ensure that custom Office Scripts are properly shared with the correct users or email addresses, especially if they are outside your domain.
Experience Powerful Macro Support with WPS Office
Tired of macro limitations in web-based spreadsheets? WPS Office provides a robust, lightweight desktop alternative with excellent support for VBA macros, ensuring your automated buttons and scripts work flawlessly offline. Enjoy high compatibility with Microsoft Office formats at no cost.
- 1. Download and Install: Visit the official WPS Office website and download the free desktop application for your operating system.
- 2. Open your Workbook: Launch WPS Spreadsheets and open your existing .xlsm or .xlsx file containing macros.
- 3. Enable Macros: Click on the Developer tab to manage and run your VBA macros seamlessly without web-based restrictions.
Frequently Asked Questions
Why do my Excel worksheet buttons work for me but not for my team?
If your buttons are tied to VBA macros, they will not function if your team is opening the file in Excel for the Web. They need to open the workbook in the Excel desktop application.
Can I run Office Scripts on a shared workbook if I am outside the owner's domain?
If you are outside the owner's domain, the script might not be accessible by default. The owner must explicitly share the script with your specific email address to grant you access.
Are VBA macros supported in Excel for the Web?
No, Microsoft Excel for the Web does not support creating, running, or editing VBA macros. You must use the desktop version of Excel to use macro-enabled features.
What should I do if shared users get an error when clicking an Office Script button?
Verify that the users have Edit access to the workbook. Additionally, check the Automate tab to ensure the script itself has been actively shared in the workbook settings by the owner.
