Run Time Error 438 in Excel Sheet

Hi @Bhosale Pravin, 

Thank you for posting your question in the Microsoft Q&A forum. From what I’ve found, Runtime Error 438 means “Object doesn’t support this property or method.” This usually happens when VBA code tries to use a property or method that isn’t available for the object in question. After Office 365 updates, this error often appears because of broken VBA references or compatibility issues. 

To better understand your scenario and provide the most accurate assistance, could you please share a few details: 

• What version of Excel or Office 365 are you currently using (you can check under File > Account > About Excel)? 
• Does the error pop-up as soon as you open the file, or only when you click a macro button inside the sheet? 
• Is the file using VBA macros or ActiveX controls? And if possible, a screenshot of the error message would be very helpful. 
• Please try launching Excel in Safe Mode: Press Windows Key + R, type excel /safe, and check if the file works there.  

I also noticed your post is tagged under the Business channel. Just to confirm, are you using a Microsoft 365 Business account provided by your organization or school, or a personal Microsoft account? If it’s a Business account, does this issue affect only your device or multiple users in your organization? Knowing this will help us understand whether the problem is local or widespread. 

While we wait for those details, here are some initial troubleshooting steps you can try: 

1. Repair the VBA references  

Open the VBA editor by pressing Alt + F11, go to Tools > References, and look for Microsoft Office Object Library and Microsoft Excel Object Library. Uncheck them, click OK, then go back and re-check them. This refreshes the link and often clears the error. 

2. Open and Repair the file 

Close Excel completely, then go to File > Open, browse to your e-invoice file, click the dropdown next to the Open button, and choose Open and Repair, then select Repair. 

 3. Enable ActiveX/Macro content  

Go to File > Options > Trust Center > Trust Center Settings, then under ActiveX Settings, choose Enable all controls without restrictions and without prompting (if you trust the source). 

If these steps don’t resolve the issue, please be patient and share the details I mentioned earlier in the comments. I’ll continue researching and work on finding a solution that best fits your situation.  

Thank you so much for your understanding and cooperation. Looking forward to your reply! 

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.  

Solution Found with Enable ActiveX/Macro content we changed Active X Setting & Sheet is Working Properly.

Thanks for the Solution.