Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Feb 2003
    Location
    Bournemouth, Dorset, England
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unprotect (xl 97 and above)

    Does anyone know of any code/program that will unprotect a spreadsheet that has been password protected and where the password has been lost?
    A spreadsheet at work was created years ago, I need to update it, but the guy who originally created it password protected the file and has now left.

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Unprotect (xl 97 and above)

    The following sites can help you do this:
    1/ http://www.mcgimpsey.com/excel/removepwords.html - a vba routine you can use to remove passwords from worksheets. This is for when you can open the file but individual worksheets are password protected.
    2/ http://lhttp://www.erlandsendata.no/englis...hp?t=endownload - a very good free add-in to remove passwords. It allows you to remove passwords for workbooks that need a password to open them but this will probably take a very long time. You can also use it to remove worksheet passwords.

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

    Re: Unprotect (xl 97 and above)

    If it is the worksheet that is protected, see if <!post=THIS MESSAGE,283683>THIS MESSAGE<!/post> will solve your problem.
    Legare Coleman

  4. #4
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    London, United Kingdom
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unprotect (xl 97 and above)

    I have found this download to be very useful. http://www.straxx.com

    It adds menu options on the toolbar to unprotect sheet or unprotect workbook.

Posting Permissions

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