+ Reply to Thread
Results 1 to 5 of 5

How To : Digital Certificate for Workbook

  1. #1
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,015

    How To : Digital Certificate for Workbook

    .

    Moderators: Please don't 'trash can' this post. I'm looking for assistance/information regarding Digital Certificates. The problem to be solved is "How To" ?


    I've read some information regarding obtaining a Digital Certificate for a file. All very confusing to me - never attempted before.

    Have you accomplished this previously ?

    QUESTIONS:

    Are digital certificates just for networks ?

    If not, what exactly is the advantage to having a Digital Certificate for my workbook ?

    How does it protect the workbook - or does it ?

    If this is something that I can obtain, can it be done without cost ?

    What are the steps in obtaining a Digital Certificate ?


    All of this may be very simple but I really don't understand the purpose of Digital Certificates.

    Thank you.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,437

    Re: How To : Digital Certificate for Workbook

    See these articles

    https://support.office.com/en-gb/art...a-98505ecd1c01
    https://support.office.com/en-gb/art...0-92e3e9a49483
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,015

    Re: How To : Digital Certificate for Workbook

    Thanks Andy.

    I've gleaned one thing from the articles. Please correct me if I'm wrong. Digital Certificate only means the author
    assures the users the project is safe to use.

    Yes / No ?

    But then the articles go on to say its possible for someone else to change the certificate ? Is that correct ?

    If so, I'm still confused. Why use Digital Certificates ?

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,437

    Re: How To : Digital Certificate for Workbook

    If you self sign then the certificate will remain unless the code is changed. So the only thing it tells the user is that somebody has altered the code in some way since the author signed it.

    If you pay for a Digital cert then the supplier of the cert may carry out some checks of the author/company before the certificate is issued.
    Doing a quick search I can not find anywhere that states they actually check the code.
    And this page would suggest they don't https://www.thawte.com/about/contact...ng-misuse.html

    Another article that maybe relevant
    http://www.wiseowl.co.uk/blog/s240/d...for_macros.htm

  5. #5
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,015

    Re: How To : Digital Certificate for Workbook

    .
    This is a very enlightening article you shared :

    Another article that maybe relevant
    http://www.wiseowl.co.uk/blog/s240/d...for_macros.htm
    It gives the ins and outs of a Digital Certificate then proceeds to explain why it isn't worth the effort.

    I'll mark this thread as solved. I believe I have a better understanding of Dig Cert now.
    Thank you for your assistance.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Remove Digital Certificate
    By skchow in forum Excel General
    Replies: 2
    Last Post: 07-10-2012, 12:20 PM
  2. digital certificate questions
    By bluegirl01 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-25-2008, 03:48 PM
  3. [SOLVED] Transfer existing digital certificate
    By clapper in forum Excel General
    Replies: 2
    Last Post: 02-02-2006, 07:00 PM
  4. digital certificate
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2005, 03:05 PM
  5. [SOLVED] SP2 & Self signed Digital Certificate
    By Bill James in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-03-2005, 03:05 AM
  6. digital certificate being discarded from a shared workbook
    By TLS in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-04-2005, 02:05 AM
  7. Using Digital Certificate
    By smcash in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2005, 12:06 PM
  8. [SOLVED] Digital Certificate
    By phil in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-20-2005, 05:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1