Signing Excel macros with a self-signed certificate RRS feed

  • Question

  • We have a company website on our intranet, not on the Internet.  We want to sign the macros in our Excel spreadsheets with a self-signed certificate.  The spreadsheets should open without giving any security warnings.  If we use the Office Tool called "Digital Certificate for VBA Projects" to create the self-signed certificate, users do get a security warning.  Also the certificate is good for 6 years, and we'd like to specify a longer time.

    If we use makecert.exe to create a self-signed certificate, we can sign the macros with it, but then when we save the spreadsheet, Excel says it's not a vaid certificate.

    Is there a way to do this?

    • Moved by Mike Walsh FIN Thursday, April 15, 2010 3:42 AM Not a (SharePoint Extended Edition only) Excel Services question. (From:SharePoint - Excel Services (pre-SharePoint 2010))
    Thursday, April 15, 2010 2:13 AM