auto protection of cells
 

Imagine someone is putting figures representing hours worked in a worksheet
under the correct weekday, job, etc .
Can I automatically protect cell entries imediately after being filled
(previously were blank) to avoid accidentally over writing them..??
and in the event that I do indeed want to overwrite (because the operator
made a mistake) allow me to do so perhaps after ticking some okay box ??

You could use a worksheet_change event to make it automatic to:
unprotect
change the cell(s) to locked
protect

--
Don Guillett
SalesAid Software

"castro" wrote in message
...
Imagine someone is putting figures representing hours worked in a
worksheet
under the correct weekday, job, etc .
Can I automatically protect cell entries imediately after being filled
(previously were blank) to avoid accidentally over writing them..??
and in the event that I do indeed want to overwrite (because the operator
made a mistake) allow me to do so perhaps after ticking some okay box ??