Are you sure that this is what's happening?

Could it be that the users are clearing the cells (not clearing the contents),
then get the error when they try to add a new value to that previously unlocked
cell?

It this describes the problem, then you have a couple of choices.

#1. Teach the user to use Edit|Clear|Contents (not Edit|Clear|All) or just hit
the delete key to clear the contents of the cell.

#2. Change the normal style of your workbook so that the default cell
protection is not locked.

In xl2003 menus:
Format|style
Select Normal from the dropdown at the top
Click the modify button
Select the protection tab and uncheck Locked

Now when the users clear (completely clear--not clear contents), the cell will
return to normal--and you've made the normal protection Unlocked.

But Styles live in workbooks. You'll have to do this for each workbook that
needs it.

Sue C wrote:

I have a spreadsheet which allows users to enter values, and then
automatically calculates various summaries from this. Before protecting the
sheet I have Locked the cells which have formulas in them, but left the
others Unlocked for data entry. This works fine until the user tries to
delete an entry they have made into an Unlocked cell, at which point they
receive an error message saying that the sheet is protected. As they are
only trying to clear an entry that they have made, I want to allow them to do
so, and can't really understand why Excel is blocking this when the cell
isn't Locked. Any suggestions? Thanks. Sue

--

Dave Peterson