System Error &h80004005 (-2147467259)

[djreiswig]

Have been working on a rather large project in VBA in Excel. Today when I went to view my code it says "Project is unviewable" Then it says System Error &h80004005 (-2147467259). Unspecified error". I have done some searching, but haven't been able to decipher this error.

I have not changed anything on the computer since I last opened this file (yesterday). It just seems that Excel decided to lock my code. The macros seem to work fine from the sheet, I just can't view or edit them anymore.

Is there anyway to correct this error? I do have an older version of this file that works fine, but I have made some changes to this version that I will have to recreate. Any ideas?

 

[shg]

I have no experience with that error, but you might see if you can run CodeCleaner: http://www.appspro.com/Utilities/CodeCleaner.htm

 

[djreiswig]

Thanks for the suggestion. I downloaded CodeCleaner and tried it, but it doesn't list my project in the box. Only Personal.xls.

 

[shg]

Did you trust access to the project?

In 2003, Tools > Options > Security, Macro Security, Trusted Publishers tab, tick Trust access ...

 

[djreiswig]

I'm actually using 2000 at work. I checked and the box is checked and my "home made" certificate is in the list. It has been working fine except for today. I couldn't get it to work on 2003 at home either.

 

[shg]

Is the workbook shared? If so, unshare it and try.

Meanwhile, I'll ask someone smarter than me to look in on this.

 

[djreiswig]

Not that I know of. At least I never made it that way. Is that something Excel can come up with on its own? I'm thinking Excel goofed something up and now it doesn't want to play anymore.

 

[shg]

If it were shared, it would say [Shared] in the title bar, at least in Excel 2003. Assuming it doesn't,

1. Try removing the signature and see if you can view the project.

2. Try sharing the workbook, save, close, and reopen, then unshare the workbook.

 

[djreiswig]

shg4421, You are AMAZING!!!

Your second suggestion worked great. I now have access to my code again. You saved me a couple of hours of work. Guess I'll have to remember that trick for when Excel gets stupid on me again.

I know I never shared it, cause I had problems locating how exactly to do that. Took a little googling to figure it out.

Thanks again.

 

[SaraWitch]

Can I just add my thanks nearly 10 years on!! This had never happened to me before today and I freaked out because I have sooooo many projects running on this particular workbook. But the sharing and unsharing solution worked!

I love this forum and it's clever members!!