Dear Laurel,
Apologies for the inconvenience caused to you. Before giving you the best solution, could you share the exact error message you're seeing? If possible, please provide a screenshot to help us diagnose the issue more effectively.
Based on your description, here are some methods you can try:
Method 1: Check for Disabled Macros: Go to File > Options > Trust Center > Trust Center Settings > Macro Settings and ensure macros are enabled.
Method 2: Look at the Button's Code: If the button runs a macro, you can open the Visual Basic Editor (Alt + F11) and inspect the code for errors.
- In the Project Explorer (left panel), look for:
- ThisWorkbook
- Modules
- Sheet Objects (where the button is located)
- Check if any of these contain error messages or corrupted code.
Method 3: See If an Add-in Is Missing: If the button relies on an Excel add-in, check under File > Options > Add-ins to see if one is inactive or missing.
Method 4: Try a Different Computer or User Account: If possible, open the file on another device to see if the problem persists.
If the issue still persists, unfortunately, as forum moderator, I don’t have access to the backend systems to troubleshoot this effectively due to privacy and security constraints. For that reason, the most efficient solution would be to:
- If this is a file from an external provider, you may need to approach the developer or IT support
- If this is a file from your workplace, contact Microsoft’s support team directly to report issue and get confirmation about this feature. And the related supported team will further help you; you will get a more detailed and professional answer to your query there.
***Note:***If you’re an end-user, please coordinate with your Office 365 Global Administrator to handle these steps.
If you still have problems, please let me know and I will continue to help you with the problem.
Looking forward to hearing from you.
Best Regards,
Microsoft Community Support Specialist