Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Security Issue with macro (2003)

    I am having an issue with a macro. I created it in 2003. It works on my computer. I sent to contract person, and they are getting an error message. I had created on one worksheet and forget to copy with the one I emailed. That problem is resolved. Now, he gets the security warning. He has changed his setting but still gets the "Macros are disabled because the security level is set to High and a digitally signed Trusted Certificate is not attached to the macros. To run the macros, change the security level to a lower (not recommended), or request the macros be sgined by the author using a certificate issued by a Certificate Authority" error message.

    What else can I do?

    Thanks,
    Deborah

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

    Re: Security Issue with macro (2003)

    It looks like the user's macro security is still set to High, or else (s)he hasn't closed and reopened the workbook with the macro after changing the macro security level.
    The correct sequence is:
    - Close the workbook containing the macro.
    - Select Tools | Macro | Security...
    - Select Medium, and click OK.
    - Open the workbook containing the macro.
    - The user should get a warning that the workbook contains macros, and click the button Enable Macros.

  3. #3
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Security Issue with macro (2003)

    Further to Hans' recommendation, after the user has opened the file in the Medium Security mode they can self certify the code as described here.
    Regards
    Don

Posting Permissions

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