Hi. I have a worksheet that has a self-signed certificate attached to its vba project (which is locked by the way). When i open th file i my PC a warning comes (because 've set macro security to disable all macros with notification) and the options are to prevent the code to run, enable content or trust code from publisher. If i choose this last option my certificate is now installed in trusted publishers and now everytime i open the file no warning appears. So far so good. The problem is when i take the same file to my job computer. Now i try to open the file, the same warnig appears but now it says that the digital signature is invalide and not trustworthy. So all macros will be disable. And it does not give me the option to enable content or trust content from the publisher as my home pc gives. I click "Show signature details" and manually instal the certificate in trusted publishers. Go back and the option of enable content or trust content still not visible. The only option avaiable is "Help me protect from unknown content (recommended)". Click OK. Go to trust center and confirm that the certificate is installed in trusted publishers and now close the file. Re-open it and the same security warning comes up with the same only option avaiable and not letting macros to be enabled. But now the certificate is installed. Dont understand why it the other options dont appear.
I'm running excel 2007 and windows 7

Regards.

Really hopping for sollutions because i'm tired of searching google and anybody has an answer.

Thank you