Home |
Search |
Today's Posts |
#1
|
|||
|
|||
cells not protected
I'm having a little problem with Excel 2002. I have recently seen two
unrelated instances (from unrelated users) where a sheet was protected, but I was able to enter values in cells that were locked. I have used Excel in all its versions over a period of 20 years and I haven't seen this happen before. Does anyone know how this is happening? Thanks, Tedr |
#2
|
|||
|
|||
Tedr
Excel 2002 is the first version to allow users with permission to edit locked cells. ToolsProtection"Allow users to edit ranges" Gord Dibben Excel MVP On 1 Dec 2004 12:22:31 -0800, (Tedr) wrote: I'm having a little problem with Excel 2002. I have recently seen two unrelated instances (from unrelated users) where a sheet was protected, but I was able to enter values in cells that were locked. I have used Excel in all its versions over a period of 20 years and I haven't seen this happen before. Does anyone know how this is happening? Thanks, Tedr |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
split combined Time Date cells | Excel Discussion (Misc queries) | |||
Averaging only cells with data | Excel Discussion (Misc queries) | |||
Calculating without including Hidden Cells | Excel Discussion (Misc queries) | |||
Cells losing formatting | Excel Discussion (Misc queries) |