Home OS Windows Run-time error 1004, Cannot run the Macro in Excel

Run-time error 1004, Cannot run the Macro in Excel

Some folks have been complaining concerning the Excel runtime error 1004. From the outset, this error might come off as an enormous downside, however in reality, it’s extra of a distraction than anything. Run-time error 1004 might happen if Excel doesn’t get entry to Microsoft Visual Basic for Applications (VBA) or Macros.

Excel Error 1004

We say this as a result of the runtime error 1004 is straightforward to repair, subsequently, people shouldn’t be shedding their minds over it. Yes, we do perceive that it slows your workflow, however when you get an thought of the way to spin issues round, you’ll be simply tremendous. Now, it have to be acknowledged that anybody who faces this error is not going to have the choice to make use of sure useful resource libraries. Furthermore, there could be efficiency issues and fixed crashes to make utilizing Excel much more tough.

What is Runtime error 1004 in Excel

From our expertise, the error seems principally when the consumer tries to run MS Visual Basic for Applications Macro. The whole factor is a safety process to lock MS VBA from Excel, but when the consumer decides to present it entry, then runtime error 1004 will doubtless by no means seem. The error message might have a number of variations, and they’re:

  • Runtime error 1004: Application-defined or object-defined error
  • Runtime error 1004: Copy technique of Worksheet Class Failed
  • Error 1004: Programmatic entry to Visual Basic Project isn’t trusted

Fix Error 1004 in Excel

The very first thing you may be required to right here is to open Excel Options, which is straightforward. Just open Microsoft Excel, then click on on File, and from there, choose Options.

Once you’re within the Options space, please click on on Trusted Center, then Trust Center Settings.

Fix Error 1004 in Excel

Right away the Trust Options part ought to seem. From there, please choose Macro Settings.

Finally, click on on Trust entry to the VBA challenge object mannequin, then hit the OK button and that’s it for that.

Scan for malware

As a matter of precaution, you might need to additionally scan for malware, so you should definitely fireplace up your anti-malware scanner and carry out an everyday scan to see if something pops up. If nothing comes up, then we recommend performing a full virus scan to ensure all is properly.

Microsoft Defender is a superb software for this job, but when that’s not sufficient in your eyes, then we recommend utilizing a free standalone malware scanner.

Most Popular

Nvidia, Intel, and AMD GPU shipments up 10.8% as consumers scoop up PCs

Demand is sky high for GPUs, according to industry intelligence firm Jon Peddie Research. In the company’s latest Market Watch report...

AI still struggles to recognize hateful memes, but it’s slowly improving

Facebook in May launched the Hateful Memes Challenge, a $100,000 competition aimed at spurring researchers to develop systems that can identify memes intended to...

Andy Jassy’s AWS keynote revealed little about multicloud plans

In the shadow of the pandemic, a skittish post-US election economic climate, and the semi-permanent shift to work-from-home, cloud vendors are facing a groundswell...

Salesforce acquires Slack for $27.7 billion

Salesforce has confirmed that it’s buying team collaboration platform Slack, in a deal worth $27.7 billion. Salesforce said that it plans to combine Slack...

Recent Comments