How To Fix Microsoft Excel Runtime Error 438

Need help, 

Last night after finishing my work on Excel, I saved the file and close. But the next day when I try to open the same file I was getting the runtime error 438. I closed the file and restart my PC but still getting the same error message. 

Can anyone know what’s gone wrong and how to fix Excel error 438? Please help me the data is very important to me and also I had no any backup of the Excel data. Thanks in advance!!!

Well, facing Error in Microsoft Excel is a common problem. This easily gets corrupted due to the minor mistake and as a result, starts displaying errors. And runtime errors are the most common one in Excel.

Today in this article we have come with the irritating runtime error 438 being reported by the Excel users. The runtime error 438 is commonly faced by the Excel 2010, 2007 and 2002 users.   When this error appears users start receiving the error message Run-time error 438 Object doesn’t support this property or method. 

And generally, the error appears when the user starts creating a custom toolbar in Excel sheet and the user gets the error message runtime error 438 while trying to do anything in Excel. 

Excel Error 438 appears in various situations such as:

• While running MS Excel 2000 and running a Visual Basic for Applications macros
• Or when the users start the word 2002 application for the first time after upgrading from office 2000. 

                                     Also Read: How To Fix XML Errors In Excel

The most common cause of getting the Run-time error 438 is when the users create a macro that works successfully in word but due to some reason might not work in Microsoft Excel and while the users try to execute this macro in Excel sheet users start receiving the runtime error 438 in Excel.

Now to fix Excel runtime error 438, make use of the professional recommended automatic repair utility.

Automatic Solution: MS Excel Repair Tool

To fix run-time error 438 in Excel make use of the most advanced MS Excel Repair Tool. This is the best tool and designed with the advanced algorithm to fix any Excel error it doesn’t matter what is the reason behind it.

With the help of this, you can repair multiple corrupted files in one repair cycle and recovers the entire items such as charts, worksheet properties cell comments, and other important data. It is easy to use and compatible with both Windows as well as Mac operating systems. This supports the entire Excel versions and the demo version is free.

However, if you are technically savvy and want to resolve runtime error 438 in Excel manually, then here follow the solutions.

Manual Solutions to Fix Runtime Error 438 in Excel:

Method 1 – Uninstall Microsoft Works Add-in

The add-ins are however useful in some cases but this also creates a problem, so here it is suggested to uninstall the add-ins.

Follow the steps to do so: 

• First, click Start > Settings > Control Panel
• Then, open Add / Remove Programs
• In the Options box > click File Location
• And on the Uninstall/Install tab > choose the Word in Works Suite Add-in > click Add / Remove
• Next, follow the on-screen instructions
• Lastly, reboot your PC > try loading Microsoft Word again

Doing this will stop the error from appearing. After completing the whole process checks whether the runtime error 438 is resolved or not, but if this won’t work for you then run the Open and Repair utility. This repair utility is available in the Microsoft Excel application and helps to repair the corrupt, damaged, inaccessible Excel files.

Helpful article:
How To Fix Can Not Insert Object In Excel

So, it is worth giving a try.

Steps to Use MS Excel Repair Tool:

Step 1: First, download and install MS Excel Repair Tool

Step 2: And, press“Select file” > select the corrupted .xls or .xlsx file. 

Step 3:  Press Scan to scan the corrupted files after you have selected your files.

 Step 4: And after finishing scanning process, preview your corrupt files. 

Step 5: Lastly, select the preferred location to save the repaired workbook on your system    

Conclusion:

Hopefully, after reading the article you are able to fix runtime error 438 in Excel. Follow the given manual as well as automatic solutions and resolve Excel error 438 easily.

Good Luck!!!