Forum Discussion
How to do password protect on both view and edit mode?
Hi Hermes,
Thank you for answering this question for me. The sheet now requires a password to view but I'm having an issue with edit access.
I sent a test run to my coworker, but when she goes to unprotect the sheet so she can edit, she is receiving an error message (I'll copy it below) even though she's entering the password correctly. Is there a way to fix this? I have also tried it on my ends and it works perfectly.
"The password you supplied is not correct. Verify that the CAPS LOCK key is off and be sure to use the correct capitalization"
Hi Hermes,
Thank you for answering this question for me. The sheet now requires a password to view but I'm having an issue with edit access.
I sent a test run to my coworker, but when she goes to unprotect the sheet so she can edit, she is receiving an error message (I'll copy it below) even though she's entering the password correctly. Is there a way to fix this? I have also tried it on my ends and it works perfectly.
"The password you supplied is not correct. Verify that the CAPS LOCK key is off and be sure to use the correct capitalization"
Hi aishatous
This error usually occurs due to one of the following reasons:
Worksheet Protection vs File Protection: There might be confusion between worksheet protection and file protection. If you've protected the worksheet and also set a password to open or modify the file, different passwords are required. The password to modify the file is not the same as the one used to unprotect the worksheet. Make sure your colleague is using the correct password in the appropriate place.
Regional Settings Variation: Check if your colleague is using Excel with different regional settings (like English or Portuguese), which could cause issues with entering certain password characters (e.g., special characters). If the password contains special characters, try using a password with only letters and numbers to see if the issue persists.
Different Passwords for Opening and Editing: Ensure that the password you provided to your colleague is the correct one for unprotecting the worksheet. There could be one password to open the file in view-only mode and another to unprotect the worksheet for editing. Worksheet or cell protection requires a separate password, which is entered when unprotecting the sheet.
Case Sensitivity: As the error message suggests, case sensitivity might be causing the problem. Ensure there are no issues with the "Caps Lock" key or differences in password capitalization.
If these tips don't solve the issue, an alternative is to temporarily remove the worksheet protection, send it to your colleague without the password, and then reapply the protection later. This can help identify if the problem is related to the password or the software version.
- Thank you!