D
dbpeters
I have a Workbook where the cell protection is on, yet I can enter values
into the locked cells. The evidence that the worksheet is protected is in
the menu item that says "Unprotect Sheet."
I have checked the cells to make sure that they are still marked as
"locked" in the format/cell menu selection.
When I select Unprotect Cell, it prompts me for the password. If I type
the password, the sheet is still unlocked. If I then select "Protect Sheet,"
I can now lock the sheet.
This is the first time I have encountered a situation where a sheet was
unlocked when it indicated that it is locked
FYI. The Workbook is unlocked. I am using Excel 2000.
Thanks in advance for any enlightenment on the issue.
into the locked cells. The evidence that the worksheet is protected is in
the menu item that says "Unprotect Sheet."
I have checked the cells to make sure that they are still marked as
"locked" in the format/cell menu selection.
When I select Unprotect Cell, it prompts me for the password. If I type
the password, the sheet is still unlocked. If I then select "Protect Sheet,"
I can now lock the sheet.
This is the first time I have encountered a situation where a sheet was
unlocked when it indicated that it is locked
FYI. The Workbook is unlocked. I am using Excel 2000.
Thanks in advance for any enlightenment on the issue.