Run Time error 1004 method sheets of object global failed

I've just opened up a spreadsheet with some vba coding that I've been working on, on an old machine. The machine is running the same version of excel I programmed it in (2010).

I opened the spreadsheet and enabled content, then I got this error message 'Run time error 1004 method sheets of object global failed' - I couldn't step through the code because it's password protected. So I hit 'end', and went back to the spreadsheet and it seemed to be working fine. I closed it and opened it again, and the same thing happened.

I went into the vba, took off the password protection, thinking I'd save and re-open it, then at least when the error occurred I could look through the debugger. So I did, but this time the error didn't occur. I put the password protect back on, and it seems to be working fine now.

I'm just slightly worried, because I'm a vba novice and this is a work project that others are using, and I don't know how serious this error is, or whether I should be worried! I've googled around but it didn't really help me. Does anyone know what this error is, and what might cause it? Is it the password protection of the code?

Thank you.

Originally Posted by Norie

What does the code do?

Also, why are you being asked to enable content?

There's quite a lot of code, there are two user forms and various other bits.

It asked me to enable content because I'd never opened the file on this machine before. I haven't had this error before with the file, and nor has anyone else to my knowledge.

Originally Posted by Norie

Sounds to me like there might be some sort of security issue, I've encountered the 'Enable content...' thing when opening files downloaded from the internet or not from 'Trusted Sources.

Where is the file stored?

Is the problem specific to this one machine?

I downloaded it from my email - I'm self-employed and borrowed an old pc just so I had something to work with. I saved it onto the desktop.

It's only happened with this machine as far as I know - it never happened when I opened it on my old machine, and a couple of other people have used the file, and if they've had the error they haven't mentioned it to me (and they would, because I programmed it for them).