Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jul 2003
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Digital Signature (XP)

    I've created a self-signed digital signature for my macro. However, when other users open this with a setting of high, they are unable to select the enable this macro button(it is greyed out).

    What do I need to do differently?

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Digital Signature (XP)

    I have no personal experience with this. From reading this article on MSDN, it appears that the Enable button does not become enabled until the user checks the box to "Always trust macros from this source."

    Code Signing Office XP Visual Basic for Applications Macro Projects

    <IMG SRC=http://msdn.microsoft.com/library/en-us/dnoxpta/html/odc_dsvba05.gif>

  3. #3
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Digital Signature (XP)

    I've only ever got the symptoms you are reporting when the VBA Project has become unsigned. Have you checked to make sure that the digital signature has "taken"?
    Gre

  4. #4
    New Lounger
    Join Date
    Nov 2003
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Digital Signature (XP)

    Hi,

    I've discovered that the trick for this is installing your certificate on the end users computer.

    I recently did this with a certificate I made with the Selfcert.exe program. Although the user security settings were on medium -- I'm thinking on high they don't even prompt? But if you set them to medium and then check off "trust all macros from this source" I think you'll be ok to put them back on medium.

    Here are the steps to place your certificate on their computer. I don't know if there's a simpler way, like just knowing what the file name is and copying it somewhere:
    Self Cert steps:

    Use selfcert.exe to apply the certificate.
    Copy the template to the client computer.
    Run the template. You are prompted that there are macros, and there is a "trust from this source" check box, but it is disabled.
    Choose:
    Details
    View Certificate
    Install Certificate
    Next
    Auto Select Certificate store based on the type of certificate
    next
    finish
    Respond with YES to the "do you want to add" prompt.
    You are prompted SUCCESS!
    Choose Ok Ok, Ok, Enable.
    Close the document/template.
    Try opening another document based on the template.
    The "Trust all macros from this source" check box is now enabled. You can check it off, and get on with your life!!!!!!!

    Good luck to you!
    Laura

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •