Mar 25 2021 02:55 PM
Hello,
I have run into a problem protecting a worksheet.
Running Excel 365, I protected the sheet as usual: Right click on worksheet tab, Click on Protect Sheet, Entered a password anb clicked OK, Confirmed the password and clicked OK and saved the File.
If I open in my Excel 365, when I right click on the worksheet tab and click Unprotect Sheet, I am prompted for the password.
Opening the same file in Excel 2007, I can unprotect the worksheet without being promptered for a password!!
Mar 26 2021 09:29 AM
Mar 27 2021 04:17 AM
If I may recommend, send the file - workbook / worksheet (without sensitive data) with the problem. Explain your problem based on this file. So we could also check the error here and see where the error can or cannot be.
Additional question: Does this problem only arise with these worksheets? ... or also with other protected worksheets?
This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.
Thank you for you all understanding and patience
Nikolino
I know I don't know anything (Socrates)