Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Becoming a Trusted Source

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I was just wondering how to become a "Trusted Source" for a machine to avoid macro messages altogether.

    Thanks all
    Chris

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Also, is there a way to change macro securities from another macro?

  3. #3
    . MrExcel's Avatar
    Join Date
    Feb 2002
    Location
    Merritt Island Florida
    Posts
    864
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default

    One way is to pay Verisign $400 for their Office VBA Macro signing certificate.

    Then, you can sign all of your projects for one year.


    View a collection of recent Excel articles in the Excel Daily News

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    So, there is no way to create my own certificate, backed by no one, so that for my office workers they can see that it is me and not worry about a "Reliable Certificate?"

  5. #5
    . MrExcel's Avatar
    Join Date
    Feb 2002
    Location
    Merritt Island Florida
    Posts
    864
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can "self-sign", but my understanding is that the security (at least on XP) may not accept it if their security is set to High. The help file seems to say it is a corporate setting.

    There is a whole topic in the Excel help which explains this. Let me see if I can find it.

    Yes - search for "Digital Signature" in help, then look at the topic for "Add a Digital Signature for a file or macro project" Here is the relevant part:

    Because a digital certificate you create yourself isn't issued by a formal certification authority, macro projects signed by using such a certificate are referred to as self-signed projects. Depending on how Microsoft Office digital-signature features are being used in your organization, you might be prevented from using such a certificate, and other users might not be able to run self-signed macros for security reasons.

    _________________
    MrExcel.com Consulting

    [ This Message was edited by: MrExcel on 2002-03-15 07:03 ]

  6. #6
    New Member
    Join Date
    Mar 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'll look into it, thanks

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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