Macro Security and Digital signatures - PANIC HELP requested

[Roscoe]

I created a template with macros in a previous version of Excel. Do 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 update, I reattached the old
signature. It let me. Fine. Reopened the file and Excel reported the
signature as invalid and refuses to let the macros run. Selecting the
options button does not reveal the normal warning-but-let-me-use-them-anyway
button. After several activities of which were panic-driven and since
forgotten, I finally got the file to run OK…on and from my machine.
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 file and looked for the signature by selecting
“Prepare†“Show (or 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 disabled macros when I run it from the website.

Desperately in need of help!!!!!!!! (Have I made that clear

 

[bapeltzer]

I wound up spending the money (~$100/year) to have a certificate issued by a
certificate authority. Using that to sign your macros will allow '07 users
to deem you a trusted publisher.
(FWIW, I went through https://secure.ksoftware.net/code_signing.html, though
there are a number of certificate authorities out there with varying prices).

 

[Roscoe]

Unfortunately, that's not going to help me now. I need to free up this
template by finding and deleting the "invalid" signature (which if in fact it
is invalid why did Excel 2007 let me "sign" with it?).