+ Reply to Thread
Results 1 to 6 of 6

Ran Macro that Password Protected Sheets, Now won't Unprotect

  1. #1
    Registered User
    Join Date
    04-19-2013
    Location
    New Jersey, USA
    MS-Off Ver
    Excel Mac 2011
    Posts
    3

    Ran Macro that Password Protected Sheets, Now won't Unprotect

    I ran the following Macro (written for the active workbook- to turn auto calculation on, password protect each worksheet and close/save the workbook) which worked just fine, however, when I try to un-protect any of the sheets, I end up with an Incorrect Password error. Please help - currently, I cannot edit any of the worksheets in this workbook. Apologies are offered in advance if I have broken any posting rules as this is my first post.

    Please Login or Register  to view this content.
    Thanks for your help,

    PD
    Last edited by pjdumont; 05-05-2013 at 01:03 PM. Reason: Wrap Code per Forum Guidelines

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Ran Macro that Password Protected Sheets, Now won't Unprotect

    Hi PD,

    welcome to the forum.

    You need to wrap your code in below style:-
    Please Login or Register  to view this content.
    Use # button available on top when you edit your post.

    Now, try un-protecting the worksheets using code:-
    just replace the respective line with the line ws.Protect Password = "clean123"

    and let me know if this helps. thanks.


    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    04-19-2013
    Location
    New Jersey, USA
    MS-Off Ver
    Excel Mac 2011
    Posts
    3

    Re: Ran Macro that Password Protected Sheets, Now won't Unprotect

    DILIPandey:

    Thank you. I corrected my post by wrapping the code as you indicated and the suggestion you made led me to the solution to my problem.

    PD

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Ran Macro that Password Protected Sheets, Now won't Unprotect

    Great

    Please mark this thread as [SOLVED].. thanks.

    Regards,
    DILIPandey
    <click on below * if this helps>

  5. #5
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Ran Macro that Password Protected Sheets, Now won't Unprotect

    Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

    In future, to mark your thread as Solved, you can do the following -
    Select Thread Tools-> Mark thread as Solved.

    Incase your issue is not solved, you can undo it as follows -
    Select Thread Tools-> Mark thread as Unsolved.

    Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  6. #6
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Ran Macro that Password Protected Sheets, Now won't Unprotect

    IGEDIT,

    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

    Hence, your post has been removed.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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