sheet protected but cells "cleared of all" become locked

Giganews Newsgroups
Subject: sheet protected but cells "cleared of all" become locked
Posted by:  Glen
Date: Tue, 7 Aug 2007

Hi,

I have a sheet where columns headers and row labels are locked but the rest
of the sheet is open for editing.

However, random staff members occasionally empty a cell using |Edit|Clear|All|

This also resets the protection formatting for the cell, and it becomes
protected.  Is there a work around or is staff education the best option?

This is all in Excel 2003.

Cheers,

Glen

Replies