Closed Thread
Results 1 to 6 of 6

Unlock a password protected WORKBOOK

  1. #1
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Unlock a password protected WORKBOOK

    I offered to help my dad in unlocking a very old excel workbook. At first I tried the following code

    But I guess that's for opening a protected sheet.



    I also tried the code breaker for WORKBOOKS described on this link http://www.zorvek.com/excel/unlockin...and-sheets.htm
    But I couldn't get it to work.
    • Either I am pasting it on the wrong place
    • Is there a way to unprotect a workbook whose password is forgotten ?

    Moderators note: Code and link removed
    Last edited by FDibbins; 04-02-2015 at 11:32 AM.

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Unlock a password protected WORKBOOK

    Do you mean the workbook is protected so you cant modify it once you open it or the file itself needs a password before opening?
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Re: Unlock a password protected WORKBOOK

    The workbook is password protected . So when I open it, it asks for a password. In teh background, I cant see any worksheet. Please see the attached



    Passwordbreaker1.JPG
    Attached Images Attached Images

  4. #4
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Re: Unlock a password protected WORKBOOK

    see attached
    Attached Images Attached Images

  5. #5
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Re: Unlock a password protected WORKBOOK

    I did find this code in the workbook's module. Didnt know if this has anything to do with it ? See attached pic to see where I found this

    Please Login or Register  to view this content.
    Attached Images Attached Images

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,049

    Re: Unlock a password protected WORKBOOK

    Your post does not comply with Rule 11 of our Forum RULES.

    Don't post questions regarding breaking or bypassing any security measure. Such posts will be deleted, and repeat offenders will be banned. This includes posting of links to sites that offer software, code or services to do this or posting of code to remove passwords

    Thread Closed
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to unlock the password protected sheet using macro
    By Jeffri in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2014, 07:25 AM
  2. Marco to unlock my password protected workbook.
    By 11linc11 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-22-2013, 07:44 PM
  3. VBA to unlock password protected sheet using cmd button
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-18-2011, 03:27 PM
  4. How do I unlock a protected worksheet:password protected
    By Terry Swift in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2005, 09:05 PM
  5. [SOLVED] How do I unlock a spreadsheet that is password protected?
    By Moke in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-25-2005, 11: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