G
Guest
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
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