Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: what's the best way to digitally sign my spreadsheet?

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Arizona
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi! Thanks for all of your help so far... my macros are finally finished and debugged, however when I took the file to one of my clients to test it on their system, they were unable to run the macros with their present security levels. I have 65 clients and would like to know the best way to digitally sign this file so their are no problems.

    Thanks in advance for any replies!

  2. #2
    Board Regular s-o-s's Avatar
    Join Date
    Apr 2002
    Location
    Kissimmee, Florida
    Posts
    384
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-03 16:12, chouston wrote:
    Hi! Thanks for all of your help so far... my macros are finally finished and debugged, however when I took the file to one of my clients to test it on their system, they were unable to run the macros with their present security levels. I have 65 clients and would like to know the best way to digitally sign this file so their are no problems.

    Thanks in advance for any replies!
    If by sign do you mean protect your macros,

    Why not In VBE
    Right Click Modules
    VBAProject Properties
    Protection Tab
    lock Project for Viewing
    and Password Protect.

    Appologies if I am teaching you to suck eggs.

    Hope This Helps.
    Sean.
    Digest of Homes

    WinXP, XL XP

  3. #3
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-03 16:12, chouston wrote:
    Hi! Thanks for all of your help so far... my macros are finally finished and debugged, however when I took the file to one of my clients to test it on their system, they were unable to run the macros with their present security levels. I have 65 clients and would like to know the best way to digitally sign this file so their are no problems.

    Thanks in advance for any replies!
    You can either sef sign the workbook using
    selfcert.exe (do a search for this file)
    When the user opens up your file they'll be
    prompted with the trust and your certificate
    name....
    The users can always select the option to
    Always Trust from....and select your Cert.

    OR get one from a firm like Verasign.
    You'll have to pay. Seach msoft for there
    recommendations on this.




    Kind Regards,
    Ivan F Moala From the City of Sails

  4. #4
    Board Regular
    Join Date
    Apr 2002
    Location
    Arizona
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    password protecting the might be a good idea, but I'm trying to digitally "sign" or "certify" the file so computers set on high security will allow the macros to run.

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Location
    Arizona
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    oops, thanks Ivan, you answered while my question while I was posting my reply.

    Thanks again

    Happy Weekend

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
  •