auto protection of cells

C

castro

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 ??
 
D

Don Guillett

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