Results 1 to 13 of 13
  1. #1
    New Lounger
    Join Date
    Nov 2005
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    file protection (xp)

    I am trying to protect a spreadsheet from unwanted users using it. There are several people in our office that use the spreadsheet but our firm does not want others from other firms to be able to use the spreadsheet. I of course can use a password to protect entry into the spreadsheet, but this is not foolproof as the users at our office can simply give out the password to others and thus the protection is lost. Any thoughts on how to accomplish this?

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

    Re: file protection (xp)

    Welcome to Woody's Lounge!

    If you can't trust the employees in your office, you have a problem. You can devise all kinds of protection, but if people who can legitimately work with the workbook are out to commit fraude, it's hard to stop them. They can copy information from the workbook into an unprotected new workbook, or type information from the workbook into a new workbook, etc. No protection built into the workbook itself is going to stop them from doing this if they really want to...

  3. #3
    New Lounger
    Join Date
    Nov 2005
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: file protection (xp)

    thanks for your input. We do trust our employees, but the problem is that they do leave on occasion and work for our competitors. The spreadsheet involves a unique structural design, fully developed with our resources, and should stay within our organization.

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

    Re: file protection (xp)

    Again, there is not much you can do if someone is intent to break the rules. If an employee has legitimate access to the workbook, and can spend some time on it, it is possible to break almost any protection, or at least copy enough information out of the workbook to do harm.

    Also, I assume that those employees have intimate knowledge of the structural design, so even without the workbook, they can use that knowledge in a new job.

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: file protection (xp)

    I would like to reinforce what Hans has said. If an employees has legitimate access to the workbook, there isn't much you can do to keep him from taking what he wants. The only other alternative I can think of would be to give only one person access to the workbook, and have him parsel out the info in the book on a need to know basis. Of course, if that person leaves the company, you would have to shoot him. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Legare Coleman

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: file protection (xp)

    If this information is really that sensitive, I would suggest upgrading to Office 2003 and setting up Information Rights Management.

    This will give you full control over what is allowed to happen to a file.

    Here is more information:
    Information Rights Management in Office Professional Edition 2003
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts

    Re: file protection (xp)

    Edited by HansV to make URL clickable -see <!help=19>Help 19<!/help>

    hi..

    maybe this will help you out...

    best,
    wolfgang

    http://www.encryptor-decryptor.de

  8. #8
    New Lounger
    Join Date
    Nov 2005
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: file protection (xp)

    Thanks again. I didn't realize a user could get around the protection. I think I will remove the protection and go on with life.

  9. #9
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: file protection (xp)

    Wolfgang

    I am getting an Error with you program: Error 53 File not found: Cryption.dll

    I get this after entering/confirming a password and selecting the sheet to encrypt.

    I have first opened your EXAMPLES.xls; unlocked ALL cells; locked all yellow cells and saved the file, but left it open.

    The Crytion.dll file is indeed in the same folder as all 7 files that I unzipped.

    I ran the procedure again and got the error msg -2147467259 (800040050 Automation Error Unspecified Error
    I am running XP with XL2000

    Any suggestions?

  10. #10
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts

    Re: file protection (xp)

    hi paul...

    this seems to happen if e-2000 is used in an xp-environment....

    in that case, please copy the dll to the directory which holds your excel.exe and to windows/system32 as well...

    whit behaves like that, we don't know and as i said above, not always....

    best,
    wolfgang

  11. #11
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: file protection (xp)

    Thanks for the reply.

    In the interim I tested with a new wbk in the same directory as the unzipped program and dll. It worked well except that if I had protected my file it crashed.

    It seems to me that this could be improved slightly with a check at the beginning of your Encrypt procedure to see if the target file is protected, and if so, a message given ( like " Unable to encrypt a Protected file.") followed by an Exit Sub.

    I'll also try you suggestions. Thanks

  12. #12
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: file protection (xp)

    Wolfgang

    I notice that when I encrypt a cell, any other cell that references the first cell, now contains a #Value error. Is there a way around this?

    I was hoping to leave the file encrypted (hiding certain data and formulas), but still allow the user to use the hidden values or the formulas behind the hidden values.

  13. #13
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts

    Re: file protection (xp)

    hi paul...

    thank you very much for your suggestions...

    we will look into the first one regarding an already protected workbook...

    regarding your second question i don't think it will be that easy, because we allow individual cell protection and in your case would need to check for dependents as well as precedents....

    so far i just transform any affected cell into values...

    best,
    wolfgang

Posting Permissions

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