Runtime error 1004 when running excel macro. Other users do not have same issue with file

Hi everyone,

I am running into an issue with a file in Excel that when I try to run a macro. I get the following error:

"Run-time error '1004': Cannot run the macro 'modpaste.copy'. The macro may not be available in this workbook or all macros may be disabled."

A couple things to note:
- I just joined this company and I am using OneDrive to access and open the file
- Other users do not have a problem running the macro in the file
- I definitely have macros enabled

I don't see a macro named modpaste.copy anywhere in the different modules in VBA. I think this is some kind of access issue because no one else had the same issue.

Please help!

Noah

Hi JLG,

THanks for the quick response. Here is the snippet of code where the macro trips up:

Please Login or Register  to view this content.

Can you explain what you mean by "ensure that your system is mapped to the OneDrive directory that you use to access the file"? I am able to open and save files onto the OneDrive folders I have synced to my computer if that is what you mean.

One possibility is that you are missing an Add-in. Have a look at the Add-ins tab in Excel on your computer, and a colleagues, and see if they have something there that you don't.

We all have the same add-ins, so that's not the issue.

The problem is that I did not develop it. The person who did left the company and I don't see any modules in VBA that show what exactly that code does.