A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Hi,
It is possible that VBE6EXT.OLB is corrupted, preventing you from using macros on Microsoft Excel. To troubleshoot this issue, kindly follow these steps:
- Close the excel and find VBE6EXT.OLB in C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6.
- Rename VBE6EXT.OLB to VBE6EXT.OLD**.**
- Open Excel and right-click the ribbon.
- Check Developer and click OK.
- Under Developer tab, click Visual Basic. A pop up windows will ask you to repair the program.
- Click Yes and let the repair finish.
- Close Excel, re-open it and check if your issue has been fixed.
Let us know how things go.
Regards