Share via

Run time error '1004' Application-defined or object-defined error

Anonymous
2023-05-12T21:56:43+00:00

I have a user that got a new laptop, its on windows 10 and she keeps receiving this error message when running a macro.

I have uninstalled and reinstalled office. I went to the Macro Settings and enabled "Trust Access to the VBA project object model." I also, disabled her add-ins and ran the macro in safe mode. Kind of stuck and I do not want to reimage the computer for this one issue, but if I have to okay.

Please let me know if you have any other suggestions regarding this issue.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2023-05-12T22:07:38+00:00

    Let her do the following:

    • Activate the Visual Basic Editor (Alt+F11).
    • Select Tools > Options...
    • Activate the General tab of the Options dialog.
    • In the Error Trapping section, select 'Break in Class Module'.
    • Click OK.

    Then run a macro. The Debug button in the error message, that is disabled in the screenshot that you posted, should now be enabled, hopefully.

    Let her click Debug.

    This should take her to the line of code that causes the error - it will be highlighted in yellow.

    Does that provide a clue?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-05-15T20:58:19+00:00

    Thank you, for your quick response! It did not populate anything for her. We also seen that this is happening to any file that has a Macro enabled.

    0 comments
  3. HansV 462.4K Reputation points MVP Volunteer Moderator
    2023-05-16T07:30:05+00:00

    Some troubleshooting tips: Fixing Startup problems

    0 comments