Digtal Signature problem - PANIC

[roscoe]

I created a template with macros in a previous version of Excel that is critical to folks in my company (expense reports). To allow people to use the macros in a secure environment, I created a digital signature. Not sure what good it did but it didn't appear to break anything. Every time I edited the template, the signature would have to be reapplied. Made sense.

Upgraded to Office 2007 and now the template is broke and I desperately need it to work ASAP. After the most recent edit, I reattached the old signature like before. It let me. Fine. Reopened the file and Excel reported the signature as invalid and refused to let the macros run. Selecting the notification button did not reveal the normal warning-but-let-me-use-the-macros-anyway button...just no macros allowed period (Yes, I have disable with notification selected).

After several actions of which were panic-driven and since forgotten, I finally got the file to run OK…on and from my machine only. Uploading to my company’s SharePoint site and executing the file from there shows the same problem…invalid signature, disabled macros.

So I went back to the original file and looked to delete the signature by selecting “Prepare” but the “View signatures” option isn’t there. No evidence of a signature anywhere. I edit the file, save as another name, anything. No matter what I do, it runs fine from my computer but still shows “invalid signature” and disables the macros when I upload and run it from the website. I can only assume that will happen when others try the same thing.

Another thread that has some more background is at http://www.mrexcel.com/forum/showthread.php?t=364086.
Some kind folks tried but they ran out of ideas.

Desperately need to eliminate the signature from my file and hopefully from my computer.

Help!!

 

[roscoe]

Sorry for the bump, but this has already floated down to page 4 and I am in desperate need of help.

 

[roscoe]

Re: Digital Signature problem - PANIC

I sent this file home where I have the older Excel version, hoping that it would strip out the offending signature. I modified it, re-saved it, changed names, did everything I could do that in the past would force me to "re-sign" the document. I then sent the file back to work. I saved it to my desktop (which is not included in my trusted locations) and same problem. Claims I have an invalid signature and refuses to let me run the macros.

Folks, PLEASE, I need to fix this without turning changing macro security completely off.

I went to the Microsoft help forums and got diddly.squat from there (within 10 minutes I was on page 5 and never to be seen again). I think this is a bug but have no idea how to report this to Microsoft...

 

[roscoe]

Re: Digital Signature problem - PANIC

Well, it's fixed. I opened a new document, and copied sheets over to it and one macro module (one edit required in the module) and it seems to work fine and the invalid signature is gone.

Still have no idea what happened but that's Microsoft.

Thanks to everyone who tried (see other thread).