Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts

    proprietary spreadsheet protection

    We have a proprietary spreadsheet that may be used in litigation. Is there a way to have the spreadsheet work, but
    (1) hide all formulas from prying eyes.
    (2) be unusable after a certain date, or better yet, say 2 months after its first use.

    thanks.

  2. #2
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    When you say "a proprietary spreadsheet", do you mean that it is:
    1. an Excel spreadsheet with proprietary contents, or
    2. a non-Excel spreadsheet ?
    If the latter, what spreadsheet is it ?

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    I am uncertain of the version of Excel that you are using however, if you select the cells you wish to protect. Look in the Format Cells dialogue and choose Protection, Lock and Hide cells. When Protection is applied to the sheet, the formulas will be hidden. As for your 2nd request. I have seen over the years, code floating around that sets a timer to lock up a spreadsheet after a certain amount of time. That being said, I'm sure there would be ways to get around this. Have you considered simply saving your workbooks in PDF format?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  4. #4
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts
    The lock and hide would work. Thanks.
    As for pdf, the other side has to be able to "test" the results against their method.

  5. #5
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    When I googled "vba code timed spreadsheet lock" I found a number of discussion links on this topic, including a company that will sell you a solution (I have no idea how good/bad it its). So there are some resources out there. Best of luck.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  6. #6
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    Thanked 2 Times in 2 Posts
    There are many many programmes out there that can easily "crack" password protectred spreadsheets. You have to look at military strength encryption. I tested a couple of third party solutions a few years ago that made calculations/formulas non viewable but came to the conclusion that they were too clumsy. A possible thought could be to have a separate :input" spreadsheet for the third party that links to say a calculating spreadsheet on a thumb drive, with both the drive and spreadsheet protected/endrypted. Then the 3rd party enter variables into the input spreadsheet, which returns the answers based on the calculation spreadsheet formulas. Good luck
    Paul Coyle
    Approach love and cooking with reckless abandon

Posting Permissions

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