How To Fix Excel Macro Runtime Error 1004
January 12, 2022If you receive Excel Macro Runtime Error 1004 error message, today’s guide will help you.
Recommended: Fortect
Runtime error 1004 occurs as soon as the macro you run just copies the original worksheet into a great workbook with a distinguished name that you haven’t saved most of the time and closed before running the macro.
Runtime Error “1004” – Programmatic Access to a Visual Basic Project Is Actually Untrusted (Mac) This error looks like Office 2016 or Office 2019 on the Mac version. This error is related to the addition of a security setting to Microsoft Office settings.
Recommended: Fortect
Are you tired of your computer running slowly? Is it riddled with viruses and malware? Fear not, my friend, for Fortect is here to save the day! This powerful tool is designed to diagnose and repair all manner of Windows issues, while also boosting performance, optimizing memory, and keeping your PC running like new. So don't wait any longer - download Fortect today!
Microsoft Visual Basic for Applications (VBA) is designed to help users write programs for the Windows Sprinting System. It works as a scalable internal language in Microsoft Office in the form of Word, Excel, and PowerPoint.
This error is conditional – added security idea in Microsoft Office options. You can now open XLSTAT safely.
Some internet users reported that when running VBA on an Excel chart or creating a macro in Excel documents, they received an error message: Error Execution 1004. If you even have meetings with users, this post is about the approach for you. You can find both full causes and corresponding solutions for most of these error codes on this page.
Run-time Error Details
Open a blank workbook in Excel.Go to – File> Options> Trust Center.Click Trust Center Settings.In the Macro Options section, verify that trusted access is indeed enabled for the entire object model of the VBA project.
The error message contains much more information than the error scope code 1004. If you follow the general error code, you can see a short description. The most common error messages are listed below:
- Runtime error 1004: Application object defined or error.
- Runtime Error 1004: The Ranger object worksheet method could not be executed. Error
- Runtime 1004: Copy worksheet class method failed.
Reason Why Excel Displays Runtime Error 1004
If you want to know how to properly resolve error 1004 at runtime in Excel, you need to help you understand the cause of the obstacle. Here are the most obvious reasons.
The macro you run copies the worker You put the software into a book with a familiar name that you didn’t cut out or shut down before running the macro.
When opening VBA, the Excel image conflicts with various programs.
There are more legend entries in an Excel chart than are available to display legend entries above the chart.
How To Fix Runtime Error 1004 In Many Excel
Fortunately, while there are reasons for this Excel 1004 error problem, there are some helpful tips that can help users regain access to their core files. Let’s take a look at them one by one.
Fix 1. Remove The GWXL97.XLA Files
The easiest way to fix Excel error 1004 is to find and remove the duplicate content error in the file.
Step 3. Open your own Excel file again and check if my problem is resolved.
Fix 2: Checking Trusted Access To The VBA Project Object Model
Another decision you can make is to enable trust The new relationship for the VBA build option in the Excel Trust Center. Complete the detailed steps in just one try.
Step 1. Open a blank Excel file and click “Files” in the upper left corner.
Step 4. Enable the “Trusted access to the VBA project protest model” option. “
in macro settings
Hotfix 3: Create Another Excel Template
This method can be a little confusing, but useful and worth trying.
Step 1. Please start another Excel workbook and of course create only one worksheet around it.
Step 2. First format the workbook and then enter the required information.
Step 3. Click File> Save As, first enter a name for the story, and then click the Save button in the Type column.
Now someone can insert them programmatically with the following code: add type: = path filename. An information file is a file that you put together when you create a new Excel template.
Fix 4: Recover Corrupted Excel Files
If all of the above solutions cannot help you, the only option It is because the Excel file that everyone is trying to open is corrupted. To recover corrupted Excel file, you can rely on file recovery software. EaseUS Data Assistant recovery is an important choice.
Try another one: This error occurs when the sheet name is currently changed. If the name of your worksheet already exists and you try to assign the same label to another sheet, VBA will throw a runtime error 1004, saying “The name is already taken.” Try something completely different. “
Click the main button “Scan with this tool” and wait until you find any damaged documents. Then select the document your business needs and click “Recover”. All you need to do to recover corrupted Excel or Word file with EaseUS Data Recovery Wizard.
Download the software and follow the steps below to repair corrupted Excel files.
Step 1. Choose a location to search for corrupted EaseUS Excel files
Uninstall Microsoft Works. Press the merge type CTRL + ALT + DEL and click Task Manager. Close all currently open programs.Create another Excel template. Start Microsoft Excel on your computer.Uninstall GWXL97. XLA.
Run Data Recovery Wizard, then check corrupted or corrupted Excel files.
To do this, go back to VBE (Alt + F11) and, if necessary, click on the module symbol. Insert a new module and enter your personal code there. These situations are the most common 1004 mistakes on the market today. Hope this fixed the problem.
Find corrupted files by sorting, finding files, path, etc.
Step 3. Recover and save the Excel file in a safe place
Double-click the infected Excel file and it will repair corrupted and damaged files by itself.Damaged Excel clips. Click “Recover” to save the recovered Excel files to a specific location.
End Result
Basically, after reading it, you should have a deep understanding of how to fix runtime error 1004. If your needs can ensure that the Excel file you are trying to open is valid, the first three workarounds can help.
If you damaged Excel file, data recovery tool will be your best choice. It should be noted that in addition to corrupted EaseUS Excel files, Data Recovery Assistant can also help you with virus attacks, accidental file deletion and sudden system crash.
Working Solutions | Step by step troubleshooting |
---|---|
Fix 1. Remove GWXL97.XLA files | Fix any Excel 1004 error to find the file error and remove it. Go to C: Program Files MS Office Office XLSTART … Follow Steps |
Fix only. Check Trust to Access a Specific VBA Project Object Model | Download this software and fix your PC in minutes.