Excel 365 VBA Library not found -> Tools-References are greyed out

Question

Excel 365 VBA Library not found -> Tools-References are greyed out

Ulrich Duerr 0

Excel VBAs do not work in new Office 365 environment. Error mesage is "missing library". The tab tools-> references is greyed out. The VBA7.dll exists in the .../Microsoft Shared./... folder, which is not exactly the same as in my other setups. VBA works for MS Access. Any idea what i can do ?

0 comments

2 answers

Your answer

Answer 1

Susmitha T (INFOSYS LIMITED) 2,690 Microsoft External Staff

Thank you for reaching out!

This issue occurs when Excel's VBA component is not properly installed or registered in Microsoft 365. Please run Microsoft 365 -> Change -> Online Repair and ensure Visual Basic for Application is enabled.

After repair or reboot, Open Excel VBA and verify Tools -> Reference is available.

Let me know if you need any further help with this. I will be happy to assist.
If you find this helpful, Kindly mark the provided solution as "Accept Answer", so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

Susmitha T (INFOSYS LIMITED) 2,690 Reputation points Microsoft External Staff

2026-01-14T06:27:43.34+00:00

Hi, hope you’re doing well. We’re following up on this thread to check if the issue is still occurring or has been resolved. If it has been resolved, kindly mark the answer as accepted. We will proceed with thread closure by 16th January.
Looking forward to your response.
Susmitha T (INFOSYS LIMITED) 2,690 Reputation points Microsoft External Staff

2026-01-16T07:12:33.81+00:00

As we haven’t received any further updates or follow-up on this thread, we will be proceeding with thread closure. If you need additional assistance or have new information to share, please feel free to post a new thread. We’ll be happy to support you further as needed.
Ulrich Duerr 0 Reputation points

2026-01-29T12:39:09.8366667+00:00

somehow the issue does not appear any more. I dis not take any action. Thanks for your comments

Answer 2

It sounds like you're encountering a common issue with missing references in VBA for Excel 365. When the Tools -> References menu is greyed out, it typically indicates that there is a problem with the environment or the way the application is set up. Here are some steps you can take to resolve the issue:

Check for Missing References: Although the references dialog is greyed out, you can still check for missing references by trying to compile the code. If there are missing libraries, you will usually see an error message indicating which library is missing.
Repair Office Installation: Sometimes, repairing the Office installation can resolve issues with missing libraries. You can do this through the Control Panel by selecting Microsoft Office and choosing the repair option.
Re-register the VBA DLL: You might want to try re-registering the VBA7.dll file. You can do this by running the Command Prompt as an administrator and using the command regsvr32 VBA7.dll. Ensure you navigate to the directory where the DLL is located.
Check for Updates: Ensure that your Office 365 installation is up to date. Sometimes, updates can fix bugs related to VBA functionality.
Create a New Module: If the issue persists, try creating a new module in the VBA editor and see if you can access the references dialog from there.
Contact Support: If none of the above solutions work, consider reaching out to Microsoft support for assistance, especially since VBA works in MS Access, indicating that the issue might be specific to Excel.

By following these steps, you should be able to troubleshoot the missing library issue in Excel 365.

References:

Share via

Excel 365 VBA Library not found -> Tools-References are greyed out

2 answers

Your answer