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

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