|Subject:||sheet protected but cells "cleared of all" become locked|
|Date:||Tue, 7 Aug 2007|
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.