Closed Thread
Results 1 to 9 of 9

Unprotecting worksheet without password VBA

  1. #1
    Registered User
    Join Date
    11-25-2020
    Location
    Australia
    MS-Off Ver
    excel 16.16.27
    Posts
    2

    Unprotecting worksheet without password VBA

    Violation of forum rules
    Last edited by Glenn Kennedy; 11-25-2020 at 08:59 AM.

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,234

    Re: Unprotecting worksheet without password VBA

    Please be so kind and view our Forum Rules Here

    Your post does not comply with Rule # 7...

    7. Do not inquire about breaking the security of a protected workbook.
    Your post does not comply with Rule # 2...

    2. Programming code must be enclosed in code tags to improve readability.
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Registered User
    Join Date
    11-25-2020
    Location
    Australia
    MS-Off Ver
    excel 16.16.27
    Posts
    2

    Re: Unprotecting worksheet without password VBA

    can i delete this thread then?

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,234

    Re: Unprotecting worksheet without password VBA

    Will soon be deleted by a Moderator...

    Now that you have deleted the code...my post is pointless...

    Your initial code from Post 1
    Password breaker code...




    Sorry, I do not make the rules but just like yourself have to adhere to them...
    Last edited by Glenn Kennedy; 11-25-2020 at 09:02 AM.

  5. #5
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Unprotecting worksheet without password VBA

    sintek this code does't work anymore. MS have corrected something.

  6. #6
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,234

    Re: Unprotecting worksheet without password VBA

    Quote Originally Posted by BMV View Post
    sintek this code does't work anymore. MS have corrected something.
    Not my code...As per post 4

    OP code...
    Your initial code from Post 1
    Only posted OP code otherwise my post 2 would have no relevance cause he deleted code from initial post 1 ...

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,434

    Re: Unprotecting worksheet without password VBA

    I don't think you should have reposted the code, though I understand why. I used that same code many years ago but, as has been said, it doesn't work in current versions of Excel.

    I think the point about the rule is that no discussion should be entered into.

    The thread should be reported for the Moderators to close and lock (which I will now do).
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,036

    Re: Unprotecting worksheet without password VBA

    Administrative Note:

    Welcome to the forum.

    Sorry, but your post does not comply with Rule #7 of our Forum RULES:

    Don't post questions regarding breaking or bypassing any security measure.

    Such threads will be closed and repeat offenders will be banned. This includes posting of links to sites that offer software, code or services to do this or the posting of code to remove passwords.

    Thread closed.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,804

    Re: Unprotecting worksheet without password VBA

    And all code now removed.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Unprotecting sheet with known password
    By c00ly81 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-18-2015, 05:24 PM
  2. Trouble unprotecting a shared workbook with a password
    By geebeez in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-20-2013, 03:41 AM
  3. [SOLVED] Unprotecting sheet did not prompt for password
    By mhng in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-23-2006, 09:55 PM
  4. Macro asking for a password twice when unprotecting sheet
    By Tim Whitley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-20-2006, 12:55 PM
  5. [SOLVED] Password Protecting/Unprotecting Via Code
    By MWS in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-12-2005, 11:25 AM
  6. Unprotecting password protected workbook
    By Vnagpal in forum Excel General
    Replies: 1
    Last Post: 12-10-2005, 02:40 AM
  7. unprotecting a worksheet
    By Randy123 in forum Excel General
    Replies: 1
    Last Post: 08-08-2005, 01:11 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