有些人一直在抱怨Excel运行时错误 1004。从一开始，这个错误可能会成为一个大问题，但实际上，它比其他任何事情都更让人分心。如果Excel无法访问Microsoft Visual Basic for Applications  ( VBA ) 或宏，则可能会出现^(Macros)运行时错误 1004^{(Run-time error 1004)}。

我们这样说是因为运行时错误 1004 很容易修复，因此，人们不应该对此失去理智。是的，我们确实理解它会减慢您的工作流程，但是一旦您了解如何旋转事物，您就会没事的。现在，必须声明任何遇到此错误的人都无法选择使用某些资源库。此外，可能存在性能问题和不断的崩溃，使使用Excel更加困难。

什么是 Excel 中的运行时错误 1004

根据我们的经验，该错误主要出现在用户尝试运行MS Visual Basic for Applications Macro时。整个事情是从Excel锁定^(Excel)MS VBA的安全程序，但如果用户决定授予它访问权限，则运行时错误 1004 可能永远不会出现。错误消息可能有多种变体，它们是：

• 运行时^(Runtime)错误 1004：应用程序定义或对象定义错误
• 运行时^(Runtime)错误 1004：工作表类的^{(Worksheet Class)}复制^(Copy)方法失败
• 错误 1004：对Visual Basic 项目^{(Visual Basic Project)}的编程访问不受信任

修复 Excel 中的错误 1004

您需要在这里做的第一件事是打开Excel 选项^(Options)，这很容易。只需^(Just)打开Microsoft Excel，然后单击File，然后从那里选择Options。

进入选项^(Options)区域后，请点击Trusted Center，然后点击Trust Center Settings。

应立即出现“信任^(Trust) 选项^(Options)”部分。从那里，请选择Macro Settings。

最后，单击Trust access to the VBA project object model，然后单击 OK^(OK)按钮，仅此而已。

扫描恶意软件

作为预防措施，您可能还需要扫描恶意软件，因此请务必启动反恶意软件扫描程序并执行定期扫描以查看是否弹出任何内容。如果没有出现任何问题，那么我们建议执行完整的病毒扫描以确保一切正常。

Microsoft Defender是完成这项工作的绝佳工具，但如果您认为这还不够，我们建议您使用免费的独立恶意软件扫描程序^{(free standalone malware scanner)}。

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

Some people have been complaining about the Excel runtime error 1004. From the outset, this error may come off as a huge problem, but in truth, it is more of a distraction than anything else. Run-time error 1004 may occur if Excel does not get access to Microsoft Visual Basic for Applications (VBA) or Macros.

We say this because the runtime error 1004 is simple to fix, therefore, folks shouldn’t be losing their minds over it. Yes, we do understand that it slows your workflow, but once you get an idea of how to spin things around, you’ll be just fine. Now, it must be stated that anyone who faces this error will not have the option to use certain resource libraries. Furthermore, there might be performance problems and constant crashes to make using Excel even more difficult.

What is Runtime error 1004 in Excel

From our experience, the error appears mostly when the user tries to run MS Visual Basic for Applications Macro. The entire thing is a security procedure to lock MS VBA from Excel, but if the user decides to give it access, then runtime error 1004 will likely never appear. The error message could have multiple variations, and they are:

• Runtime error 1004: Application-defined or object-defined error
• Runtime error 1004: Copy method of Worksheet Class Failed
• Error 1004: Programmatic access to Visual Basic Project is not trusted

Fix Error 1004 in Excel

The first thing you will be required to here is to open Excel Options, which is easy. Just open Microsoft Excel, then click on File, and from there, select Options.

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

Right away the Trust Options section should appear. From there, please select Macro Settings.

Finally, click on Trust access to the VBA project object model, then hit the OK button and that’s it for that.

Scan for malware

As a matter of precaution, you may want to also scan for malware, so be sure to fire up your anti-malware scanner and perform a regular scan to see if anything pops up. If nothing comes up, then we suggest performing a full virus scan to make sure all is well.

Microsoft Defender is a great tool for this job, but if that’s not enough in your eyes, then we suggest using a free standalone malware scanner.

Related posts

• 如何修复 VLOOKUP 等 Excel 公式中的#N/A 错误

• 如何在Excel中录制Macro

• 如何在 Excel 中创建 VBA 宏或脚本

• Windows无法验证数字签名（Code 52）

• 修复存档以未知格式或损坏错误

• Program无法启动，因为AppVIsvSubsystems32.dll是失踪

• 哎呀！我们无法保存一个 - 的Windows Photos App

• 该PC无法升级到Windows 10由于Parity Storage空间

• 如何在Windows 11/10将Start PXE修复Start PXE

• 错误0x80073D26,0x8007139F或0x00000001游戏service error

• 在Outlook中发送或接收报告的error 0x800CCC0F

• Error 1327 Invalid Drive安装或卸载程序时

• 将属性应用于Windows 10中的文件时发生错误

• 该file install.wim对于destination file system太大

• Windows 10中的Fix ShellExecuteEx错误错误

• System error 6118，此工作组的服务器列表不可用

• MBR2GPT未能启用备份/在Windows 10还原权限

• Fix Error 0xC00D3E8E，该物业在Windows 11/10只读

• 此功能需要可移动媒体 - Password复位错误

• 如何在Windows 10修复Disk Signature Collision problem