Главная » Ошибки » How do I fix Runtime Error 1004 in Microsoft Excel?

How do I fix Runtime Error 1004 in Microsoft Excel?

What is Runtime Error 1004 in Excel?

Runtime error 1004 is an error code relating to Microsoft Visual Basic that has been known to disturb Microsoft Excel users. This error is faced by any versions of MS Excel such as Excel 2007, 2010, 2013, 2016, 2019 as well. No version of Microsoft Excel is safe from the menace of Runtime Error 1004. In some cases, you may see the runtime error 1004 in Excel after opening a worksheet. Such types of runtime errors usually occur due to a problematic add-in.

This error is mainly encountered by users while they are working on an excel file or trying to generate a Macro in the excel document. It can cause serious trouble while working with Visual Basic Applications and can completely crash a program, or even the entire system; sometimes it may freeze the system prohibiting the users to do anything on their system.

Types of error message

The error messages that are most associated with this runtime error are as follows:

  • VB: run-time error ‘1004’: Application-defined or object-defined error
  • Excel VBA Runtime error 1004 “Select method of Range class failed”
  • runtime error 1004 method range of object _global failed visual basic
  • Excel macro “Run-time error ‘1004?
  • Runtime error 1004 method open of object workbooks failed
  • Run-Time error ‘1004’: Method ‘Ranger’ of Object’ Worksheet’ Failed
  • “Method in Key up Object Program APPLICATION Failed.”
  • Run-time error ‘1004’: Activate method of Worksheet class failed

If you encounter any of these above errors, then you can fix the error using our guide.

What are the causes?

The Error 1004 is a general code related to MS Excel but is not specific to one exact cause. Hence, in this case, the exact reason why this error might pop up will vary from case to case and circumstance to circumstance. From configuration issues to software problems, below we listed a synopsis of common reasons for runtime error 1004 in excel:

  • MS Excel Desktop Icon might be corrupted
  • VBA Excel File is clashing with other application
  • Due to application or object specified error
  • Due to missing dependent file
  • Due to Virus, Trojan or malware
  • Due to Invalid Registry Keys and so on.

These were a few of the most common reasons behind getting the runtime error 1004 in MS Excel; now let us understand the different fixes.

Fix Runtime Error 1004 in Excel

Here we have detailed both manual and automatic solutions to fix the Runtime Error 1004. You can follow any one of the next methods to resolve the issue.

  1. Create a new Excel template
  2. Launch Excel in Safe Mode
  3. Run a Virus Scan
  4. For VB: run-time error ‘1004’, resize legend entries

Let’s look at each of these methods in detail.

Diagnostic tools

Microsoft have created a tool that searches your Office installations
for known problems. It is called The
Office
Configuration Analyzer Tool (OffCAT).

  • Where is the download?

You can download and install

OffCAT v1.2 from the Microsoft Download site. You can either extract
the files from OffCAT.zip or you can run the installer using OffCAT.msi.
We recommend using OffCAT.msi because it contains system requirement
checks that ensure OffCAT will properly function on your computer.

  • What is the target audience for OffCAT?

OffCAT is designed to be used by anyone that has Office installed on
their computer. This includes home users, small business people, Help
Desk professionals, Microsoft support engineers, and IT administrators.
Microsoft expects everyone to have the skillset required to follow the
directions provided in the list of detected issues. However, the
Configuration Details report is mostly aimed at moderate to advanced
users that can understand information in the registry, event logs,
Windows services and other places in Windows outside of the Office
applications.

How to Fix & Solve Microsoft Visual Basic Runtime Error 438 VBA Issue

1. Disable the Enhanced Protected Mode from Internet Explorer –

Disable the Enhanced Protected Mode from Internet Explorer
Disable the Enhanced Protected Mode from Internet Explorer

  • Open Internet Explorer
  • Click on the tools option there, on the right side
  • Click on the Internet Options there
  • On the Advanced option,
  • Uncheck the option box for “Enable Enhanced Protected Mode.”
    It’s under the Security tab
  • Now, click on Apply to apply these settings
  • Click on OK to save this configuration
  • After completing, close all the tabs there
  • That’s it, done

By disabling the Enhanced Protected Mode from your Internet Explorer browser can get rid out of this Microsoft Visual Basic Runtime Error 438 vba excel code problem.

2. Install an Automatic Repair Tool on your Windows PC –

Install an Automatic Repair Tool
Install an Automatic Repair Tool

  • Go & Search for Automatic Repair Tool on the Internet
  • Download it from there
  • Now, Click on ‘RUN‘ & Install it
  • Open it and use the automatic repair tool
  • After finish, close the tab
  • That’s it, done

By installing an automated repair tool on your Windows PC will fix this Runtime Error 438 excel vba access problem quickly from you.

3. Uninstall Microsoft Works Add-in on your Windows PC –

Uninstall Microsoft Works Add-in
Uninstall Microsoft Works Add-in

  • Click on the Start menu
  • Search for Control Panel or directly open it
  • Open ‘Add or Remove Programs‘ tab there
  • Click on the file location in the options tab
  • On the Uninstall/Install option,
  • Select the Words in Works Suite Add-in
  • Again, click on the Add or Remove Programs there
  • Follow the ON Screen instructions
  • After completing, close all the tabs from there
  • Restart your PC
  • Load the Microsoft Word again
  • That’s it, done

By uninstalling the Microsoft Works Add-in can get back you from this type of excel Runtime Error 438 VBA code issue.

4. Use a Registry Cleaner to Clean the Registry of your Windows –

Clean or Restore the Registry
Clean or Restore the Registry

Clean your registry by any registry cleaner software so that it can fix and solve this VBA Runtime Error 438 object doesn’t support access problem from your PC completely.

5. Reinstall the Drivers for the Device on your PC –

Reinstall the drivers for the device
Reinstall the drivers for the device

By Reinstalling the drivers for the device will fix your Visual Basic outlook Runtime Error 438 fix problem.

6. R un a Full Scan of your Windows PC for Malware or Virus –

Scan your PC for Virus/Malware Microsoft Visual Basic Runtime Error 438 VBA
Scan your PC for Virus/Malware Microsoft Visual Basic Runtime Error 438 VBA

  • Go to the start menu
  • Search or go to the “Microsoft Security Essentials” there
  • Click on it and opens it there
  • A Pop-up will open there
  • Check the ‘Full‘ option there to scan thoroughly
  • After, click on the ‘Scan Now‘ option to scan carefully
  • After scanning, close the tab
  • That’s it, done

By running a full scan of your PC can get rid out of this Runtime Error 438 word Excel VBA problems from your PC completely.

7. Create a System Restore Point on your Windows PC –

Fix System Restore Features Microsoft Visual Basic Runtime Error 438 VBA
Fix System Restore Features Microsoft Visual Basic Runtime Error 438 VBA

  • Go to the start menu
  • Search or go to the ‘System Restore.’
  • Clicks on it and open it there
  • After that, tick on the “Recommended settings” or ‘Select a restore point‘ there
  • After selecting, click on the Next option there
  • Now, follow the wizard
  • After completing, close the tab
  • That’s it, done

So by applying this method on your Microsoft Windows PC can quickly solve this VBA Runtime Error 438 excel MAC issue.

“ OR “

Run System Restore & Create a Restore Point Microsoft Visual Basic Runtime Error 438 VBA
Run System Restore & Create a Restore Point Microsoft Visual Basic Runtime Error 438 VBA

  • Go to the start menu
  • Search or go to the ‘System Properties.’
  • Click on it and opens it
  • After that, go to the “System Protection” option there
  • Now, click on the “System Restore” option there
  • & Create a Restore point there
  • After completing, close the tab
  • That’s it, done

Run a system restore and creating a new restore point by any of these two methods can solve this Visual Basic Runtime Error 438 ecw excel mac problem from your PC completely.

8. Troubleshoot & Run an Automatic Windows Repair on your PC –

Repair your PC (Computer) Microsoft Visual Basic Runtime Error 438 VBA
Repair your PC (Computer) Microsoft Visual Basic Runtime Error 438 VBA

  • Go to the start menu
  • Search or go to the PC settings there
  • Click on the ‘Troubleshoot‘ option there
  • After opening, click on the ‘Advanced options‘ there
  • Then, click on the “Automatic Repair” option there
  • After troubleshooting, close the tab
  • That’s it, done

By running an automatic repair of your PC can get rid out of this Microsoft Visual Basic excel vba Runtime Error 438 problem from your PC.

Windows 10 related problems

With Windows 10 many problems have been reported in the newsgroups
and fora regarding Office. Microsoft has written an elaborate article on
the known issues and their possible resolutions here:

Known issues with Office and Windows 10

Excel shows errors during startup or behaves odd

Open Excel in Safe mode

Start, Run,
“C:Program FilesMicrosoft OfficeOfficeExcel.exe” /Safe

Tip: You can also start Excel in safe mode by holding
down the control key whilst you double-click the Excel icon.

The safe switch ensures Excel starts without opening any addins or using
your menu customisations. If this works, chances are that your toolbar
customisation file is corrupt. Locate all files with extension .xlb and
rename the extension(s) to something like .old
Now try and start Excel again.

In Windows, the xlb file is found by entering this into the Windows
Explorer
address bar and pressing the Enter key:

%AppData%MicrosoftExcel

Try opening Excel without any addins or hidden workbooks

Use the Automation switch to start Excel without loading addins or
workbooks from the XLSTART folder:

Click Start, Run,
“C:Program FilesMicrosoft OfficeOfficeExcel.exe” /Automation
(Quotes mandatory, Note you may have to change the path)
If your error disappears, either an add-in or a (hidden) workbook that
is loaded upon Excel’s start bothers you.

Locate the offending file using the following steps:

Excel Add-ins.

  1. Click the File tab and select Options.
  2. Click the Add-ins tab
  3. In the dropdown near the bottom, select “Excel Add-ins” and click
    Go.
  4. Note which are checked
  5. Uncheck one
  6. Restart XL
  7. If no error, you’ve found the one causing the problem
Источники

  • https://www.thewindowsclub.com/how-to-fix-runtime-error-1004-in-microsoft-excel
  • https://jkp-ads.com/articles/StartupProblems.asp?AllComments=True
  • https://www.techinpost.com/how-fix-solve-microsoft-run-time-error-438-windows-code-problem/
[свернуть]
Решите Вашу проблему!


×
Adblock
detector