Closed Thread
Results 1 to 3 of 3

Password protected workbook (help)

  1. #1
    Registered User
    Join Date
    02-01-2019
    Location
    France
    MS-Off Ver
    365
    Posts
    1

    Exclamation Password protected workbook (help)

    Hello,

    I have a password protected workbook (Excel 2016 - XLSX format) and password has been forgotten.
    Workbook is not accessible anymore
    I remember that there was a piece of VBA code to unlock protected sheets. It was valid only until 2010 version and not applicable to a workbook as far as I remember.

    Would anyone have a technique / tool to achieve such magic ?

    Thanks a lot for your help.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,733

    Re: Password protected workbook (help)

    Look at Rule 07 in the Forum Rules at the top of the screen - no-one is allowed to give any details about by-passing Excel security, and a moderator will come along and close this thread shortly.

    Pete

  3. #3
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,212

    Re: Password protected workbook (help)

    You will not get an answer as you are breaking rule 7

    Forum Rules Please read and adhere to these simple rules!

    1. Title must briefly summarize your request. (A, Z)

    2. Programming code must be enclosed in code tags to improve readability. (A, Z)
    Please Login or Register  to view this content.
    (or use the # button)

    3. Questions that are cross-posted to other web forums must contain links to those posts on those forums or a comment to tell us where else the question has been asked. (A, Z*)

    4. Do not post a new help request in an existing thread. (B)

    5. Do not open more than ONE thread per issue here. Expect duplicates to be closed. (B)

    6. Do not post to threads where a moderator is addressing a rule violation. (B, C, Z*)

    7. Do not inquire about breaking the security of a protected workbook. (B, E)

    8. Do not private message forum moderators or members for Excel help. (A, Z)

    9. Abusive language or insults will not be tolerated. (B, Z)

    10. Do not put links to commercial sites or services or to competing forums in signatures and posts. (A, B)

    11. Do not put links to personal sites or services as your sole contribution here on the forum. (B)

    12. Do not solicit payments in your posts or signatures. (B)

    13. Only give reps to members who earned them, not just for something trivial like an acknowledgment. (B, F)



    A. Moderator will edit title or add VBA code tags or add / remove links for new members and admonish and require compliance for more experienced members.
    B. Repeat offenders will get an infraction and banned for any subsequent offence.
    C. Moderator should soft-delete posts until rule violation is resolved.
    D. Moderator should delete the post.
    E. Moderator should close the thread.
    F. Repeat offenders will lose double the rep. points they awarded. Those given rep. points will have them reversed.
    Z. No Infraction to be given.
    Z* As Z with the exception that repeat offenders will be given an infraction.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 03-28-2018, 02:49 AM
  2. Replies: 0
    Last Post: 03-28-2018, 02:49 AM
  3. [SOLVED] VBA code to update query from a password protected excel workbook and then close workbook
    By MrChipper in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-14-2017, 07:41 AM
  4. Opening Password-protected workbook, but still being prompted for password
    By dpmcgonigle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-02-2015, 12:34 AM
  5. Replies: 2
    Last Post: 11-17-2014, 04:28 PM
  6. [SOLVED] Password array to open all password protected workbook in a folder
    By rename in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-07-2012, 05:06 AM
  7. unable to close password protected workbook using VBA code in another workbook
    By abulooz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-04-2012, 08:54 AM

Tags for this Thread

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