Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macro signature? (2003)

    I just opened a spreadsheet I created last year (2005) that contained macros I created. Upon opening, I receive a notice from Excel that I need digital signature... what is this about and why? How can I ensure that macros I create are digitally signed? I would appreciate any advice - see the error message. (low res to save space)

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Macro signature? (2003)

    Don

    Simplest thing to do here is to just set the macro security to medium

    Tools-->Macro-->Security... and then select Medium
    Jerry

  3. #3
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro signature? (2003)

    Okay, of course I will do that but I just thought it odd that I would not been seen as a trusted source for macros given that it is my computer and I was the author. I could understand some other computer questioning my macro but not mine. It makes me feel like a failed parent whose child is out of control and a public menace.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Macro signature? (2003)

    You can create a digital signature using SelfCert, but this is mainly intended for personal use. See Macro Security Levels in Office 2003.

  5. #5
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Macro signature? (2003)

    Sorry, I wasn't trying to teach you to suck eggs <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    I know how you feel, but I have a habit of having it high, especially when downloading from the web, just in case. I always have it switched to medium when at work
    Jerry

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro signature? (2003)

    Without the digital signature, Excel can not tell if you wrote that macro or if it was in a file you downloaded from the WEB. You can either reduce your security level to medium or digitally sign the workbook using the selfcert program that comes with Office and then tell your system to trust that signature.
    Legare Coleman

Posting Permissions

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