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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top