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