Forum Discussion

PeDBaG's avatar
PeDBaG
Copper Contributor
Aug 01, 2023

Worksheet protection

I setup my sheet using manage protection and new password. When I try to pause protection with password it says "incorrect password" but I am able to unlock manage protection with same password. I tried changing it from manage protection but after refresh it goes same. 

excel

1 Reply

Sort By
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Aug 04, 2023

    PeDBaG 


    It sounds like there might be a conflict or issue with the password you are using to unlock the worksheet protection. Here are a few things you can try to resolve the problem:

    1. Check for Typos: Double-check the password you are entering to ensure there are no typos or extra spaces. Passwords are case-sensitive, so make sure you are using the correct uppercase and lowercase letters.
    2. Caps Lock: Verify that your Caps Lock key is not accidentally turned on while entering the password.
    3. Different Passwords: Sometimes, Excel may prompt you to enter a different password to unlock worksheet protection than the one used for workbook protection. If you set different passwords for worksheet and workbook protection, make sure you are using the correct one for the specific protection you want to unlock.
    4. Special Characters: If your password contains special characters, be sure to enter them correctly. Some special characters may behave differently or require specific keyboard combinations.
    5. Clear Password: Try clearing the password and then setting a new one. To do this, go to "Review" > "Protect Sheet," enter the current password, and leave the "Password" field blank when prompted.
    6. Corruption: In rare cases, Excel files can become corrupted, leading to issues with passwords. To check if the issue is related to corruption, try saving the workbook as a new file and see if the problem persists in the new file.
    7. Use VBA to Remove Protection: If none of the above solutions work, you can try using VBA (Visual Basic for Applications) to remove worksheet protection. Press "Alt + F11" to open the VBA editor, then go to "Insert" > "Module" and paste the following code:

    vba code:

    Sub RemoveProtection()
    On Error Resume Next
    ActiveSheet.Unprotect Password:="YourPasswordHere"
End Sub

    Replace "YourPasswordHere" with your actual password. Run the macro by pressing "F5." This should remove the worksheet protection.

    Remember to save a backup of your workbook before making any changes or running VBA code.

    If none of the above solutions work, there might be other factors at play, here a link with other options: How to unprotect the excel sheet if forgot the password

    The text was created with the help of AI.

     

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

Resources