ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Why am I able to type in a cell that is locked and protected? (https://www.excelbanter.com/excel-worksheet-functions/56263-why-am-i-able-type-cell-locked-protected.html)

VikyTurner

Why am I able to type in a cell that is locked and protected?
 
I have a large spreadsheet with some cells locked down. I lock the desired
cells and then protect the worksheet. Some cells are locked down and others I
can type in. Are there limitations to cell protection and/or locking cells? I
have never seen this behavior before.


All times are GMT +1. The time now is 11:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com